Instructions:
Questions 1-3 should be answered using an Access database. (If you need a refresher on using Access databases, see the resources on the Supplemental Information for Access Assignments page.) The database file you submit should include, at a minimum, the following components:
• true relational table(s)
• relationships report
• queries
• reports
Answer Question 4 in a Word (or compatible) document. Create a paragraph for each answer, and repeat each question from the textbook as the heading for each paragraph.
For this assignment you must hand in:
• an Access database with reports and queries as described above (the number of queries and reports will be up to you)
OR
• if you do not have access to a computer on which you can install Microsoft Access, you may use another database tool. If you do this, you must also submit the following:
• an E-R diagram of your database that clearly shows the primary and foreign keys for each table.
• a screen shot of the first page of the contents of each table. Alternatively, you may create a report that dumps the contents of a table and submit a single page of that report.
• queries that you designed to create each report. Show both the query design and the query output.
• the reports required in the assignment
In either case, you must also submit a Word document containing a report as described in the assignment instructions on page 197.
Attachment:- ASSIGNMENT.rar