Description
physical design with DBMS is the course name.
Unformatted Attachment Preview
File Types doc and docx
This lab is to Normalize each of the 4 tables from week 1:
Please follow this great tutorial on how Normalization can be achieved to optimize performance of the
database.
Bruce Fulton is the presentor.
1NF – Normalization Plain and
Simple (https://www.youtube.com/watch?v=70nyAehrrSY)
2NF – Normalization Plain and
Simple (https://www.youtube.com/watch?v=zc7ucOoj0pg)
3NF – Normalization Plain and
Simple (https://www.youtube.com/watch?v=JLwcWQA7mP8)
Create a second page in Draw.io that shows that additional tables and relationships.
Wk 2 Lab Rubric
Criteria
Ratings
command showing
the data load was
successful
showing the data
load was successful
command showing
the data load was
mostly successful
Pts
showing the data load
was marginally
successful
and/or did not show
the data load was
successful
Total Points: 100
5.7. Discuss the various reasons that lead to the occurrence of NULL values in relations
5.8. Discuss the entity integrity and referential integrity constraints. Why is each considered important?
5.9. Define foreign key. What is this concept used for?
5.10. What is a transaction? How does it differ from an Update operation?
Writing Assignment Rubric
Criteria
APA
Style/Formatting
Ratings
14.26 to >13.71 pts
Excellent
13.71 to >13.0 pts
Good
13 to >12.29 pts
Satisfactory
12.29 to >10.57 pts
Needs Improvement
10.57 to >0 pts
Unsatisfactory
No APA style/formatting errors
are readily apparent
Paper contains 1 or 2 APA
style/formatting errors
Paper contains 3 or 4 APA
style/formatting errors
Paper contains 5 or 6 APA
style/formatting errors
Paper contains more
APA style/formatting
e
Purchase answer to see full
attachment