What does it mean to say that a database displays both entity integrity and referential integrity?

Why are entity integrity and referential integrity important in a database?

Use the small database shown in Figure Q3.5 to illustrate the difference between a natural join, an equijoin, and an outer join. The SQL script files (Oracle and SQLServer) for all of the data sets used available in Moodle.

Create the basic ERD for the database shown in Figure Q3.5.

Both the Chen and Crows Foot solutions should be shown. (used the PowerPoint template to produce the first of the two Crows Foot ERDs and Visio Professional to produce the second of the two Crows Foot ERDs.

Create the relational diagram for the database shown in Figure Q3.5.

You can create The relational diagram, generated in the Microsoft Access or any

Suppose that you have the ERM shown in Figure Q3.8.

 

Table name: STUDENT Database name: Cho3 CollegeQue Table name: PROFESSOR