1 / 21

Databases

Databases. Your Phone Bill is a database …. Flat File. CUSTOMERS. CALLS. Entities Relationships One to many Records Tables. CUSTOMERS. CALLS. CUSTOMERS. CALLS. SELECT ALL from CUSTOMERS, CALLS where Customers.number = calls.number and call.number =5556453.

jayme
Download Presentation

Databases

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Databases Your Phone Bill is a database…

  2. m.cosgrave@ucc.ie www.mikecosgrave.com @mikecosgrave

  3. m.cosgrave@ucc.ie www.mikecosgrave.com @mikecosgrave

  4. Flat File m.cosgrave@ucc.ie www.mikecosgrave.com @mikecosgrave

  5. CUSTOMERS CALLS m.cosgrave@ucc.ie www.mikecosgrave.com @mikecosgrave

  6. Entities • Relationships • One to many • Records • Tables m.cosgrave@ucc.ie www.mikecosgrave.com @mikecosgrave

  7. CUSTOMERS CALLS m.cosgrave@ucc.ie www.mikecosgrave.com @mikecosgrave

  8. CUSTOMERS CALLS SELECT ALL from CUSTOMERS, CALLS where Customers.number = calls.number and call.number=5556453 m.cosgrave@ucc.ie www.mikecosgrave.com @mikecosgrave

  9. Finding Entities and Relationships 1946 Foreign Office List – service histories People, postings, etc What are the Entities? The relationships? Draw an ER Diagram m.cosgrave@ucc.ie www.mikecosgrave.com @mikecosgrave

  10. Sample solutions to ER Diag exercise m.cosgrave@ucc.ie www.mikecosgrave.com @mikecosgrave

  11. 1901 Census of Ireland m.cosgrave@ucc.ie www.mikecosgrave.com @mikecosgrave

  12. 1901 Census Forms m.cosgrave@ucc.ie www.mikecosgrave.com @mikecosgrave

  13. 1901 Census Forms m.cosgrave@ucc.ie www.mikecosgrave.com @mikecosgrave

  14. Here’s one I prepared earlier.. • 1901 Census in LibreOffice Base • Parts of Database • Tables • Queries • Forms • Reports m.cosgrave@ucc.ie www.mikecosgrave.com @mikecosgrave

  15. Query By Example • Show QBE m.cosgrave@ucc.ie www.mikecosgrave.com @mikecosgrave

  16. Structured Query Language m.cosgrave@ucc.ie www.mikecosgrave.com @mikecosgrave

  17. Interrogating data • Individuals • Families • Buildings • Landholder • Class of Building • List of specific out buildings • So how would you dig out • Literacy by Age? • Literacy by occupation? • Literacy by homeownership? • Religion and home ownership? • Children not in school? • Live in servants? • Servants and class of house? m.cosgrave@ucc.ie www.mikecosgrave.com @mikecosgrave

  18. SQL Exercise m.cosgrave@ucc.ie www.mikecosgrave.com @mikecosgrave

  19. Hollerith, 1890 Census, Hollerith Cards m.cosgrave@ucc.ie www.mikecosgrave.com @mikecosgrave

  20. Coding, Datatypes m.cosgrave@ucc.ie www.mikecosgrave.com @mikecosgrave

  21. Coding exercise m.cosgrave@ucc.ie www.mikecosgrave.com @mikecosgrave

More Related