– Normalization, Transaction Management and File Organization
.
1.
Consider
the data file ‘sales.csv’, which has sales data for a fictitious company with
first line showing the sales attributes (fields) and each subsequent line
showing a separate sales record. Each sales record has values for sales
attributes (fields). You are asked to store ONLY A RELEVANT PORTION of the sales data in a relational
database which can have tables only in 3NF.
(You are reminded that a 3NF table necessarily should also be in 2NF and 1NF.)
i)
Select a subset of attributes
(fields) which you will store in your relational database and explain your
reasons
for your selection. |
(1) |
ii)
Create
the required database schema for the above requirements and list your database
schema as a set of relation schemas (table schemas). You are reminded that a
single relation schema (table schema) is written as shown below taking the
DreamHome.Staff relation as an example:
Staff
(staffNo,fName,lName,position, sex, DOB, Salary,branchNo) |
|
Primary Key staffNo |
|
Foreign Key
branchNo references Branch(branchNo) |
(4) |
|
|
iii)
Explain how each relation schema in your database is in 3NF. |
(3) |
2.
Consider the following Student
table in a University Student Records database.
student
StudentId |
|
fName |
|
lName |
discipline |
432987 |
|
Related Questions in computer science category
Get Higher Grades Now
Tutors Online
Warning: require_once(/home/u706648698/domains/calltutors.com/public_html/service_page_footer.php): failed to open stream: No such file or directory in /home/u706648698/domains/calltutors.com/public_html/Assignment.php on line 380 Fatal error: require_once(): Failed opening required '/home/u706648698/domains/calltutors.com/public_html/service_page_footer.php' (include_path='.:/opt/alt/php73/usr/share/pear') in /home/u706648698/domains/calltutors.com/public_html/Assignment.php on line 380 |
Sun | Mon | Tue | Wed | Thu | Fri | Sat |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | 6 | 7 |
8 | 9 | 10 | 11 | 12 | 13 | 14 |
15 | 16 | 17 | 18 | 19 | 20 | 21 |
22 | 23 | 24 | 25 | 26 | 27 | 28 |
29 | 30 | 1 | 2 | 3 | 4 | 5 |