Question: The goal for this assignment is for you to create a data model using SSMS diagrams. You will need to specify the primary key and

 The goal for this assignment is for you to create a

The goal for this assignment is for you to create a data model using SSMS diagrams. You will need to specify the primary key and at least one natural key unique index per table. Here's the scenario... A company has a lot of projects going on and wants to better manage their portfolio of projects. To do this they have decided to make a database driven application. They have hired you as their database programming consultant to design the database according to their requirements. The organization is divided into multiple companies. Each company is responsible for their own projects. Occasionally, a project may involve multiple companies. Projects can be defined, but not yet assigned any employees. And there are certainly employees that don't work on any projects. All employees belong to one and only one company. In terms of details, we really need to track the name of the company, project and employees. In addition to the first and last name, we also need the corporate email address of the employee We need to know the anticipated start date and end date for each project. We also need an estimated budget for each project. Each item is worth 5 points except #7, which is worth 3 points for a total of 33 points. 1. Correct entities (tables) 2. Correct relationships 3. Correct primary key 4. Correct index for alternate key/unique index 5. Correct attributes (columns, datatypes and nullabililty) 6. Meaningful data in each table (2 rows per table) 7. Select statements for each table showing all the data for each table (no need to join tables). Sort the results by the indexed column(s)

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