Question: Project 3 Creating Database ( 1 5 0 Points ) Instructions: Based on the following ER diagram, relational schema, create HAFH Database. Then Insert the

Project 3 Creating Database (150 Points)
Instructions:
Based on the following ER diagram, relational schema, create HAFH Database. Then Insert the sample data into the database. After inserting the data, please take a screenshot for each table. The screenshot format requirements are listed at the end of the assignment.
Deliverables:
All Sql query for the HAFH reality database. This includes queries for creating the database, tables data loading (insert query), and then the queries showing the content of every tables (e.g., show table Manager, the number of columns it has and the instances showing the data i.e., number of rows and columns in the table-see sample screenshot)(30 points)
Make sure to clearly label each part of the assignment. A lack of clarity in the submission (inclusive of sql codes, screenshots) may result in a significant deduction of points.
Screenshots after running sql query to extract all the columns from tables. There are 9 tables so there should be 9 screen shots. Requirements for screen shots:
a. One screenshot for one table points
Project 3 Creating Database ( 1 5 0 Points )

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 Programming Questions!