Question: # 1 and 2 please Using the following enterprise: - A university faculty that consists of a number of departments (Faculty of Arts and Sciences
# 1 and 2 please
Using the following enterprise: - A university faculty that consists of a number of departments (Faculty of Arts and Sciences for example). 1.) Model the data for the enterprise you have selected using Entity-Relation (E-R) diagrams. There must be a minimum of 5 entity sets. 2.) Identify the following in your design (if there is any): Keys Constraints - these include: o Referential Integrity (Foreign Key) o Not Null Constraints o Check Constraints o Default Constraints o Unique Constraints - At least one instance of a referential integrity constraint, one instance of a constraint on attributes and one instance of a constraint on tuples must be present in your design. Using the following enterprise: - A university faculty that consists of a number of departments (Faculty of Arts and Sciences for example). 1.) Model the data for the enterprise you have selected using Entity-Relation (E-R) diagrams. There must be a minimum of 5 entity sets. 2.) Identify the following in your design (if there is any): Keys Constraints - these include: o Referential Integrity (Foreign Key) o Not Null Constraints o Check Constraints o Default Constraints o Unique Constraints - At least one instance of a referential integrity constraint, one instance of a constraint on attributes and one instance of a constraint on tuples must be present in your design
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
