Chapter 7 Homework – Normalization of Relational Tables
In the ever-evolving landscape of education, students face increasing challenges to meet the demands of their academic pursuits. Striking a balance between extracurricular activities, personal commitments, and a rigorous academic curriculum can be overwhelming. Amidst this struggle, online homework help services have emerged as invaluable resources for students seeking academic excellence. Among these, HomeworkProWriters.com shines as a beacon of light, standing tall as the best website for homework help.
Module/Week 5 Homework Assignment
Chapter 7 Homework
PART 1: (1 point)
Given the following table, identify the functional dependencies:
|
StdSSN |
StdCity |
StdClass |
OfferNo |
OffTerm |
OffYear |
EnrGrade |
CourseNo |
CrsDesc |
|
S1 |
SEATTLE |
JUN |
01 |
SPRING |
2009 |
3.5 |
C1 |
DB |
|
S1 |
SEATTLE |
JUN |
02 |
FALL |
2009 |
3.3 |
C2 |
VB |
|
S2 |
DENVER |
JUN |
03 |
SPRING |
2010 |
3.1 |
C3 |
OO |
|
S2 |
DENVER |
JUN |
02 |
FALL |
2009 |
3.4 |
C2 |
VB |
|
PART 2: (1 point)
In the table provided below, fill in the following data such that it is completely un-normalized. That is, it is not even in 1NF.
222-33-44444 John Doe Web Design, Database, Intro to MIS, C# Programming
555-66-7777 Jane Doe Prin. Of Accounting, Auditing I, Statistical Analysis
|
SSN |
StudentName |
Courses |
|
|
|
|
|
|
|
|
PART 3: (1 point)
Using your un-normalized table above, fill in the table below with the data in 1NF.
|
SSN |
StudentName |
Courses |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
PART 4:
Given the following table and functional dependencies, construct tables below that will satisfy 2NF and identify the primary key of each new table. Note that the primary key of this table is StdSSN + OfferNo.
|
StdSSN |
StdCity |
StdClass |
OfferNo |
OffTerm |
OffYear |
EnrGrade |
CourseNo |
CrsDesc |
|
S1 |
SEATTLE |
JUN |
01 |
SPRING |
2009 |
3.5 |
C1 |
DB |
|
S1 |
SEATTLE |
JUN |
02 |
FALL |
2009 |
3.3 |
C2 |
VB |
|
S2 |
DENVER |
JUN |
03 |
SPRING |
2010 |
3.1 |
C3 |
OO |
|
S2 |
DENVER |
JUN |
02 |
FALL |
2009 |
3.4 |
C2 |
VB |
Functional dependencies:
StdSSN Ã StdCity, StdClass
OfferNo à OffTerm, OffYear, CourseNo, CrsDesc
StdSSN, OfferNo à EnrGrade
(1/2 point)
|
|
|
|
|
|
|
|
|
|
|
|
Table 1
Primary Key: _______________________________
(1/2 point)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Table 2
Primary Key: _______________________________
(1/2 point)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Table 3
Primary Key: _______________________________
PART 5:(1/2 point)
Now, assume an additional functional dependency:
CourseNo à CrsDesc
What table above needs to be modified to accommodate this new functional dependency?
_______________________________
PART 6:(1/2 point)
Given this new functional dependency, create tables below that will put this table in 3NF.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Table 4
Primary Key: _______________________________
|
|
|
|
|
|
|
|
|
|
|
|
Table 5
Primary Key: _______________________________
PART 7:(1/2 point)
Identify any foreign keys in Table 4: _______________________________
At the core of HomeworkProWriters.com lies a team of exceptional and proficient writers. Each member of this distinguished cadre possesses advanced degrees in their respective fields, empowering them with the knowledge and expertise to tackle assignments from various academic disciplines. From complex mathematical problems to intricate literary analyses, their writers exhibit a remarkable ability to deliver impeccable content that adheres to the highest academic standards. One hallmark of the best homework help website is its comprehensive subject coverage. HomeworkProWriters.com leaves no academic stone unturned, catering to students across diverse subjects and levels of study. Whether it be fundamental sciences, nursing, humanities, social sciences, or technical disciplines, this platform ensures that no student is left without the support they need to excel.
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!
NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.
