Reference no: EM13770169
See the glossary and index of your book for term definitions, but DO NOT copy and paste. Write them in your own words.
Give and describe an example of a supertype-subtype relationship, other than one shown in the textbook. Illustrate your answer using an IE Crow's Foot E-R diagram.
Define the three types of recursive binary relationships, and give and describe an example of each, other than the ones shown in the textbook.
Show how to represent the 1:1 recursive relationship in your answer to question 2. Describe how this differs from the representation of 1:1 nonrecursive relationships? Illustrate your answer using an IE Crow's Foot E-R diagram.
Show how to represent the 1:N recursive relationship in your answer to question 2. Describe how this differs from the representation of 1:N nonrecursive relationships? Illustrate your answer using an IE Crow's Foot E-R diagram.
Show how to represent the M:N recursive relationship in your answer to question 2. Describe how this differs from the representation of M:N nonrecursive relationships? Illustrate your answer using an IE Crow's Foot E-R diagram.
Create a Relational Database Design for the data model you developed for question 6 from Assignment 4 (where you've added Projects and Supplies - Remember that in a database design you cannot have N:M relationships. You must use intersection tables.) For each entity in the E-R model (Illustrate your answer using an IE Crow's Foot E-R diagram), specify a table structure using Access, showing the data types, additional column properties, and identify all primary and foreign keys. Write statements in your Word document that verify normalization on the resulting tables. Also document referential integrity constraint enforcement actions and any business rules that you think are important.
Use Microsoft Visio to create your Crow's Foot Diagrams and Access to show your database model.
Please submit your assignment as a Word document with accompanying Visio and Access files (required).
Give the Visio and Access files names that include your last name so I can identify them from other student files.
Number and restate each question before your answer in your Word doc.
This assures that you answer each question and that I know which question you're answering.
Paste cropped screen shots of the Visio diagrams and of the Access tables and relationships into the Word document and make sure they are legible.
Submission of all work is expected to look professional. Neatness and clear organization are taken into consideration when grading all assignments.