Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started