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# 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!