Database Design Language

In the design process, there must be a mechanism to represent tables and keys. The shorthand notation that you have used so far represents tables and primary keys but it does not represent other related keys. An approach to represent tables and keys including primary, alternate, secondary, and foreign keys is Database Design Language (DBDL).

In Module Four, you selected a topic for your Final Project and began designing your database. As of now, the tables should be normalized and not contain update anomalies. Depending on the business model or assumption, check what type of relationships the tables have. If one-to-one, treat it as one-to-many. If one-to-many, no need to change anything. If many-to-many, create a new table to handle the many-to-many relationship.

In this assignment, you will present your tables using database design language (DBDL). On a Word document:
Identify all keys in each data table (i.e., primary key, alternate key, secondary key, and foreign key) when applicable.
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.
To understand how your work will be assessed, review the Scoring Rubric. Click for more options
Click on the assignment title link above to submit your completed assignment.