Database IT244
1Draw the corresponding ERD for the following Employee Database
2Normalize the following Schema with the given functional dependencies into BCNF
3Explain in your own words why the Student-Dept relation is not in 4NF. Then, convert the Student-Dept relation in 4NF. Also, provide the justification for each step you perform during normalization (4NF). Note: The SportActivity here means any sport a student is participating in. For example, a student with ID = 123 can participate in soccer and badminton
4In your own word, explain why do designers use Denormalization? What is the limitation of using Denormalization? Name and explain a better alternative approach than Denormalization.
6 years ago 10
Answer(0)
other Questions(10)
- Topic 2
- Mini-Case Assignment3
- Assignment 2: Preliminary International Marketing Report
- Criminal Justice Forum responses
- Credit History Worksheet
- read and write recent news article and summarize >>by answering some questions
- Marketing research
- Assignment: US Government
- PowerPoint
- SEC 360 Exam Solutions (Taken March 2016)