INF2603
[Type the company name]
Assignment 5
(COMPLETE
ANSWERS) 2025 -
DUE 5 September
2025
NO
PLAGIARISM
[Year]
, Exam (elaborations)
INF2603 Assignment 5 (COMPLETE
ANSWERS) 2025 - DUE 5 September 2025
Course
Databases I (INF2603)
Institution
University Of South Africa (Unisa)
INF2603 Assignment 5 (COMPLETE ANSWERS) 2025 (865742) - DUE 5
September 2025; 100% TRUSTED Complete, trusted solutions and
explanations. Ensure your success with us....
Without using chartGP and examples from the book provide an example to
emphasize your case, describe the situations when a 3rd NF relation is in
BCNF and when it is not. Because you are a registered student at UNISA and
you have classmates who are your friends, please write SQL code to enter
your own correct information and also the information of anther student into
the STUDENT table. That is 2 records. For the student number of your friend
you can use What is the difference between a column constraint and a table
constraint? (What three join types are included in the OUTER JOIN
classification? (6) What is a strong (or identifying) relationship? (2) Why is a
table whose primary key consists of a single attribute automatically in 2NF
when it is in 1NF? (2) Without using chartGP and examples from the book
provide an example to emphasize your case, describe the situations when a
3rd NF relation is in BCNF and when it is not. Explain what is a disjoint
subtype? And give an example. (4) What three join types are included in the
OUTER JOIN classification? (6) What is a strong (or identifying) relationship?
(2) Why is a table whose primary key consists of a single attribute
automatically in 2NF when it is in 1NF? (2) f. What is metadata? (2) g. Explain
what is physical independence in data models? (2) Using the following
transport business rules, draw the appropriate ERD using UML notation for a
unique e-hailing taxi service in Mpumalanga. Make sure that you include all
appropriate entities, relationships, and multiplicities: • One driver can be
assigned to multiple taxis over time, but each taxi has only one driver at a
time • Each customer can have multiple rides, and the e-hailing services
offer sharing options for the customers • One taxi can be used for multiple
rides • Each ride has one payment, and the customer can decide to cancel
and the payment will be reversed Create an ER model for each of the
following descriptions: • A large organization has several parking lots, which
are used by staff. • Each parking lot has a unique name, location, capacity,
and number of floors (where appropriate). • Each parking lot has parking
spaces, which are uniquely identified using a space number. • Members of
staff can request the sole use of a single parking space. Each member of
staff has a unique number, name, telephone extension number, and vehicle
[Type the company name]
Assignment 5
(COMPLETE
ANSWERS) 2025 -
DUE 5 September
2025
NO
PLAGIARISM
[Year]
, Exam (elaborations)
INF2603 Assignment 5 (COMPLETE
ANSWERS) 2025 - DUE 5 September 2025
Course
Databases I (INF2603)
Institution
University Of South Africa (Unisa)
INF2603 Assignment 5 (COMPLETE ANSWERS) 2025 (865742) - DUE 5
September 2025; 100% TRUSTED Complete, trusted solutions and
explanations. Ensure your success with us....
Without using chartGP and examples from the book provide an example to
emphasize your case, describe the situations when a 3rd NF relation is in
BCNF and when it is not. Because you are a registered student at UNISA and
you have classmates who are your friends, please write SQL code to enter
your own correct information and also the information of anther student into
the STUDENT table. That is 2 records. For the student number of your friend
you can use What is the difference between a column constraint and a table
constraint? (What three join types are included in the OUTER JOIN
classification? (6) What is a strong (or identifying) relationship? (2) Why is a
table whose primary key consists of a single attribute automatically in 2NF
when it is in 1NF? (2) Without using chartGP and examples from the book
provide an example to emphasize your case, describe the situations when a
3rd NF relation is in BCNF and when it is not. Explain what is a disjoint
subtype? And give an example. (4) What three join types are included in the
OUTER JOIN classification? (6) What is a strong (or identifying) relationship?
(2) Why is a table whose primary key consists of a single attribute
automatically in 2NF when it is in 1NF? (2) f. What is metadata? (2) g. Explain
what is physical independence in data models? (2) Using the following
transport business rules, draw the appropriate ERD using UML notation for a
unique e-hailing taxi service in Mpumalanga. Make sure that you include all
appropriate entities, relationships, and multiplicities: • One driver can be
assigned to multiple taxis over time, but each taxi has only one driver at a
time • Each customer can have multiple rides, and the e-hailing services
offer sharing options for the customers • One taxi can be used for multiple
rides • Each ride has one payment, and the customer can decide to cancel
and the payment will be reversed Create an ER model for each of the
following descriptions: • A large organization has several parking lots, which
are used by staff. • Each parking lot has a unique name, location, capacity,
and number of floors (where appropriate). • Each parking lot has parking
spaces, which are uniquely identified using a space number. • Members of
staff can request the sole use of a single parking space. Each member of
staff has a unique number, name, telephone extension number, and vehicle
