Please help me solve this Data Managment excercise exam for practice purposes. 1
ID: 3810926 • Letter: P
Question
Please help me solve this Data Managment excercise exam for practice purposes.
1536 Bata Management Systems Total: 65 pts Read all the questions before starting. They are in no particular order of difficulty. Ask questions you need to. Write neatly otherwise you may lose points. Mark clearly if you additional sheets of paper 1. (6 pts) Match the following terms with their definitions. Be aware that there are extra definitions. a. contains two (or more) attributes super type b. constraint between two attributes anomaly composite k c. inconsistency or error d. generalized entity type relation referential integrity constraint e. keeps redundant columns f. established in relational data models by p natural join use of foreign keys g. does not keep redundant columns h. two-dimensional table of data without multi-valued attributes 2. (4 pts Name and briefly describe each step of the development process of a a database project.Explanation / Answer
1)
Composite key -- contains two attribute
anomaly -- inconsistency error
super type -- generelized entity type
relation -- constraint between two attribute
refrential intregrity constraint -- established in relational data model by forign key
natural join -- keep redudant column
2)
1) Find the information and object that need to stored
2 )Divide the information into tables
3) Turn information items into columns
4) Specify primary keys -
5) Set up the table relationships
6) Apply the normalization rules
3)