Using the sql server diagramming tools

Assignment Help Basic Computer Science

Reference no: EM13718176

Implement a Data Model

For this assignment, you'll implement the data model below in your database, using the SQL Server diagramming tools. Implement the data model EXACTLY as it is shown. The Table names, field names, data types, nullable fields, keys, and relationships all need to be exactly as in the model below.

To hand in the assignment, you will create a Word document, and copy-and-paste the diagram into the word document. You will upload the word document into Entropy to hand in the assignment. I will be able to check your database directly on the server if I need more information.

This data model is meant to capture an initial quote that a company might give a customer. See this sample printed quote. If the customer accepts the quote, then it becomes a sale. Note that addresses are not included - only references to some other table are included (addressIDs). I'll provide the actual diagram with the info via email when I secure a tutor. This is an MIS database management class.

Reference no: EM13718176

Questions Cloud

Constant specific heats-change in specific entropy : Nitrogen gas (N2) undergoes a process from p1 = 10 bar, T1 = 300 K to p2 = 12 bar, T2 = 1000 K. Assuming ideal gas behaviour, determine the change in specific entropy, in kJ/(kg K), assuming:

Differences and similarities between windows 7and windows 8. : Complete steps that cover the differences and similarities between Windows 7and Windows 8.1. In your APA formatted Paper answer the questions below.1. Discuss three differences and three similarities in the configuration of a Windows 7 for a h..

Estimate the work done by the gas on the bullet : A 110-g bullet is fired from a rifle having a barrel 0.594 m long. Choose the origin to be at the location where the bullet begins to move. Determine the work done by the gas on the bullet

Determine the thermal efficiency of the cycle : A steam power plant operates on a simple Rankine Cycle between the pressure limits of 10MPa and 50kPa. The mass flow rate of the steam is 50kg/s. The quality of the steam at the turbine exit is 90%.

Using the sql server diagramming tools : Implement the data model below in your database, using the SQL Server diagramming tools. Implement the data model EXACTLY as it is shown. The Table names, field names, data types, nullable fields, keys, and relationships all need to be exactly ..

How long did it take to reach the maximum height : A volleyball player throws a ball straight up from 1.5 m off the ground (so x=1.5m at t=0s) and catches it 1.4 seconds later. How long did it take to reach the maximum height

Determine the power input to this compressor : Air is compressed from 100 kPa and 20C to 700 kPa in an adiabatic compressor with an isentropic efficiency of 90%. Assuming that the mass flow rate is 0.1 kg/s determine the power input to this compressor, in kW, and the rate of entropy generated. Us..

Find how many meters does it travel before stopping : The driver of a 1720kg car traveling on a horizontal road at 102km/h suddenly applies the brakes. How many meters does it travel before stopping under these conditions

Power cycle operates between two reservoirs : A power cycle operates between two reservoirs having temperature 700 K and 300K, respectively. QH is the heat (thermal energy) received from the hot reservoir. QL is the heat rejected to the cool reservoir. Wmech represents the mechanical work produc..

User Account

All Pages