Create a relational database design for the data model

Assignment Help Database Management System

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.

Reference no: EM13770169

Questions Cloud

Perform a visual interpretation of the dionysian procession : Taking the given primary source as a guide, perform a visual interpretation of the Dionysian procession on the Florence Cup.

Define major differences of the social contract theories : Summarize the major differences of the social contract theories. What are the key principles associated with Locke's social contract theory

How to find quantity supplied given just the price : How to find quantity supplied given just the price

Is it ethical to lie to obtain to the truth : Is it ethical to lie to obtain to the truth? Do the ends justify the means? IUs there a conflict between the code of ethics and how law enforcement is really conducted

Create a relational database design for the data model : Create a Relational Database Design for the data model you developed for where you've added Projects and Supplies - Remember that in a database design you cannot have N:M relationships.

Identify assumptions on which your theory is based : Identify assumptions on which your theory is based. What methodologies could you use to evaluate it

What should your funding request include : You are considering acquiring new equipment for the cardiac catheterization lab. You have the option to lease, or to buy the equipment. Your proposal will need to be vetted or cleared through the CFO, who will want all the details and reasoning in..

Examine why religion tends to be deemphasized in society : Examine why religion tends to be deemphasized in society, and second, to explore the value of studying religion.. Considering the reasons listed above, discuss why you think these objections to religion are valid or invalid and give several argume..

Liability of a health care organization : Respondeat superior is a legal concept that deals with the liability of a health care organization. It states that an employer may be liable for the actions of its employee and, in some cases, for the wrongful acts the employee performed.

User Account

All Pages