Design a database that keeps track of projects and managers. You need to maintain information on the following fields: project id, project name, project type, project start date, manager id, manager...


Design a database that keeps track of projects and managers. You need to maintain information on the following fields: project id, project name, project type, project start date, manager id, manager last name, manager first name, manager title, manager email



Note the following conditions:



1. Project id determines project name, type, and start date.



2. Manager id determines manager's last name, first name, title, and email.



3. Each project is managed by one manager.



4. Each manager may manage multiple projects.



Provide in your answer detailed table definitions and required relationships indicating linking columns.



Jun 09, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here