Database Design Language
List DBDL for each of your tables using the format described in the “Database Design Language (DBDL)” section (p. 181) in Chapter 6 of Concepts of Database Management. For an example, review Figure 6-1.
Missing attributes for each table.
Do not include spaces in column names.
Names cannot be AK because they are not unique identifiers. An example of AK is SSN.
AdvisorID is not FK in Advisor table.
This final project is two-part and allows you to demonstrate skills acquired throughout the course. First, you will construct a database by using Microsoft Access 2013 or newer. You will select a system and data sets that represent data in healthcare, university, or other related fields, describe a problem of the selected system, and perform database design. Then, using Microsoft Word, you will write a Final Report based on the developed database.
Database Requirements
Your database in Microsoft Access must have at least:
Two tables
Two forms
Two queries
Two reports (created from queries)
In Module Four, you began to work on your Final Project and, as of now, you should have at least two data tables. All tables should have one-to-many relationships and should not contain any update anomalies. In this assignment, you will finish the database part of your Final Project by creating tables, forms, queries, and reports in MS Access.
Watch the Creating a Database in MS Access videos and do the following in MS Access:
Create your tables and enter all the data in your tables.
Create two forms.
Why do we need a form? A form is an interface between users and the database. Usually, regular users should not go to the tables and enter the data directly to the tables. Users should enter data via a form. That way, users can manipulate data but not the design of tables. In real life, the database administrator should be the only person who can make changes to the database design.
Create two queries.
Selected data can be retrieved based on criteria specified in the query.
Create two reports.
Reports are created based on queries. Unlike queries, reports show selected data in a report format.
Save the MS Access file with your name in the filename.
Final Report
The Final Report is a documentation of your database development, not to be confused with “reports” in “Database Requirements” section; they are not the same thing. Use the Report Writing Template Click for more options for formatting your Final Report. In the template, you will find a guideline for headings and details that should be included in the report. Your Final Report must be formatted according to APA standards.
To understand how your work will be assessed, view the Scoring Rubric. Click for more options
Click on the assignment title link above to submit your completed assignment. Be sure to upload both your Microsoft Access database and Final Report Word document.
