This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Example a) Write a relational schema for this E-R diagram in a Word file. Underline primary keys and indicate foreign keys. b) Using Access, create the database to correspond to the schema. Name the database YourLastNames.acdb c) Insert several records (at least 3) into each table. d) In the Word file, write out (in English) five questions that could be used as queries (i.e., what would you look for in these tables?). e) In Access, using Query-by-Example (QBE), design the queries, and execute them. Refer back to previous exercises to see how to do this. Save your database. f) Save the Word document as YourLastNames_Lab4.doc and submit with the database file (the .acdb file) by the deadline....
View Full Document
- Spring '14
- Management, partner, following ER diagram