Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following ER diagram and respective relational tables are the output from the first two phases (conceptual and logical) Your task is to complete the

image text in transcribed

The following ER diagram and respective relational tables are the output from the first two phases (conceptual and logical) Your task is to complete the physical phase and create an Access database, which includes the database tables arrived at. Submit your access database on Brightspace Submission: You need to submit both: (A) A word file with the SQL queries for creating the tables. Name this file q2Queries (B) You also need to submit an Access file with the database created. Name this database q2Da- tabase. (How you create the database is up to you: You can either create the database manually by using the GUI of Access, or create the database by running the queries you write in (A). 2. Name E ID Employee Address 1 Assigned anages Project Proj_ID Dept ept ID LocationProj_Name ocation ept _Nam Tables: Employee(E IDE-Name,Add) FK Dept(Dept ID,Dept_Name,Location,Managesr) FK Project(Proi ID,Location,P roj_Name, E_ID)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

Describe six biases affecting perception.

Answered: 1 week ago

Question

State the three objectives of the book.

Answered: 1 week ago