database and design-Q2
Ahmad571
1NF-3NFtables.docx1NF
|
Campus |
Course |
Subject code |
Year |
Semester |
Title |
covenorID |
Covernor name |
CovernorOffice |
Address |
|
Melbourne |
BIS |
IFN001 |
2019 |
1 |
Database |
000001 |
John Doe |
B101 |
185 Spring St,MelbourneVIC 3000 |
|
Melbourne |
BIS |
IFN001 |
2019 |
1 |
Database |
000001 |
John Doe |
B101 |
185 Spring St,MelbourneVIC 3000 |
|
Melbourne |
BIS |
IFN001 |
2020 |
2 |
Database |
000002 |
Jack White |
C221 |
185 Spring St,MelbourneVIC 3000 |
|
Melbourne |
BIS |
IFN101 |
2020 |
1 |
Programming |
000003 |
Will Black |
D415 |
185 Spring St,MelbourneVIC 3000 |
|
Melbourne |
BIS |
IFN101 |
2020 |
2 |
Programming |
000003 |
Will Black |
D415 |
185 Spring St,MelbourneVIC 3000 |
|
Melbourne |
BIS |
IFN202 |
2020 |
2 |
Is Consulting |
000002 |
Jack White |
C221 |
185 Spring St,MelbourneVIC 3000 |
|
Melbourne |
MBA |
HI5001 |
2019 |
1 |
Accounting for business decisions |
123456 |
Steve Brown |
H234 |
185 Spring St,MelbourneVIC 3000 |
|
Sydney |
MBA |
HI5001 |
2020 |
1 |
Accounting for business decisions |
125555 |
Katy Salivan |
A001 |
6/91 york,ST,Sydney NSW 2000 |
|
Sydney |
MBA |
HI5001 |
2020 |
2 |
Accounting for business decisions |
125555 |
Katy Salivan |
A001 |
6/91 york,st,Sydney NSW 2000 |
|
Sydney |
MBA |
H15002 |
2020 |
1 |
Finance for business |
125555 |
Katy Salivan |
A001 |
6/91 york,st,Sydney NSW 2000 |
2NF
|
Covenor ID |
Covernor name |
CovernorOffice |
Address |
Campus |
|
000001 |
John Doe |
B101 |
185 Spring St,MelbourneVIC 3000 |
Melbourne |
|
000002 |
Jack White |
C221 |
185 Spring St,MelbourneVIC 3000 |
Melbourne |
|
000003 |
Will Black |
D415 |
185 Spring St,MelbourneVIC 3000 |
Melbourne |
|
123456 |
Steve Brown |
H234 |
185 Spring St,MelbourneVIC 3000 |
Melbourne |
|
125555 |
Katy Salivan |
A001 |
6/91 york,St,Sydney NSW 2000 |
Sydney |
3NF
|
Covenor ID |
Covernor name |
CovernorOffice |
Course |
|
000001 |
John Doe |
B101 |
BIS |
|
000002 |
Jack White |
C221 |
BIS |
|
000003 |
Will Black |
D415 |
BIS |
|
123456 |
Steve Brown |
H234 |
MBA |
|
125555 |
Katy Salivan |
A001 |
MBA |
