Assignment 1 - Chapter 7 - MIS 3775 Data and Information Management Logical Data
ID: 3910727 • Letter: A
Question
Assignment 1 - Chapter 7 - MIS 3775 Data and Information Management Logical Database Design ENTERPRISE LEVEL ENTITY-RELATIONSHIP DIAGRAM Faculty Reports To Department Taught By Offers Counts Toward Course Enrolls In Atends Degree Student Receves Receives Applies For Scholarship You should fully discuss and/or respond to each of the following items. Include the item number and related text at the beginning of your discussion for each item. Prepare your discussion for all nine items in one Word document and then upload the file to your eLearn dropbox for this course (4 pts) In priority order, list the three most important points made by your instructor in each of the presentation videos for this chapter (6pts) Explain with a specific example how a unary relationship type can be mapped into tables based on the three different cardinalities: one-to-one, one-to-many, and many-to-many. You need to come up with your own examples instead of using the same ones in the textbook (Figure 7.10-13 on pp164-165) (13 pts) Convert the Video Centers of Europe, Ltd., ERD in Exercise 2.2 (p.39 in Chapter 2) into a well-structured relational database (for each relation, clearly specify primary key, alternate key(s), and foreign keys) (5 pts) Describe the following term: Functional dependency. Why is functional dependency so important in the logical database design? (3 pts) Describe partial functional dependency. If partial functional dependencies are located in a database, how you correct for this anomaly (be specific)? (15pts) Review Exercise 4 on Pages 195-197 in your textbook and answer all of the sub- questions a) - e) 1. 2. 3. 4. 5. 6.Explanation / Answer
Please Note: You have posted more than one Questions. As per Chegg Answering Guidelines, I answered the first question. Please Post Separate for other Questions.
Q1) - Information missing in the Question.
Q2) How unary relationship can be mapped into tables using 3 cardinalities - one-to-one, one-to-many, many-to-many?
Answer)
The degrees of relationships are known as cardinalities where a number of occurrence of the entity from one table is associated with the occurrences of another table or entity.
There are 3 cardinalities:
one-to-one (1:1)
one-to-many (1:M)
many-to-many (M:N)
one-to-one is where the occurrence of one entity relates to one occurrence of the other entity.
one-to-many is there one occurrence of an entity is related to multiple occurrences of another entity.
many-to-many is where many occurrences of an entity can be related or mapped to many occurrences of another entity.
one-to-one example would be than One Employee is allocated to One Company Car.
one-to-many example would be that one Department can have Many Employees working in the department.
many-to-many example would be where there are many Projects and there are many Employees. Many Employees many work in several different projects.