|
|
This is only a preview of the paper
Click here to register and get the full text.
Existing members click here to login
|
|
|
... ” (Connolly & Begg (2002), “Database Systems”, pp. ... Resulting in the chance of inconsistencies in the database. ...
Modification – If we wish to modify the Course_Desc for a particular course, we would have to update all tuples that have that course and could result in an inconsistent database if not modified correctly. ...
The 1NF for the Q2 relation is shown below:
EmployerCourse
Emp_No Name Department Salary Phone Course_Attended Course_Desc Date_Completed
F1100 Margery Jackson Warehouse $21,000 5677 PRG-VB
Programming, Visual Basic
06/12/1996
F1100 Margery Jackson Warehouse $21,000 5677 SYS-1 Systems Analysis L1 16/01/1998
F1245 Stewart Grainger Accounting $44,000 1117 TX-LAW Tax Law (Intro) 29/07/1988
F2233 Fred Frenzy IT $49,000 5677 PRG-C++
Programming – C++
13/09/1997
F2233 Fred Frenzy IT $49,000 5677 SQLI – DB2 SQL Intoduction – DB2
12/07/1999
F2233 Fred Frenzy IT $49,000 5677 PRG-PERL Programming in PERL 17/03/2000
F111 Lorenzo Oil Finance $56,000 3455 DBA-DB2 Database Administration – DB2 13/11/2001
F1109 Susan Bite Sales $13,000 3421 CLERK
General Clerical Course
31/10/2001
F1109 Susan Bite Sales $13,000 3421 SEC-90 Typing (90 WPM) 12/05/2002
Find the highest normal form (HNF) of EmployerCourse Relation
1. ... (Connolly & Begg (2002), “Database Systems”, pp.
Approximate Word count = 1421
Approximate Pages = 5.7
(250 words per page double spaced)
|
|
|
|
|
|