Submit a consolidated word document with the diagram

Assignment Help Database Management System

Reference no: EM13192554

Given the following sample database diagram, do the following:

2126_Database diagram.png

Create the needed tables in the SQL server environment (just tables, no relationships yet).

Use integer (INT) data types for all ID columns.

Hire_Date, Start_Date, and End_Date should all be DATE data types.

Salary and Commission_Pct should be DECIMAL data types.

All other data types should be VARCHAR.

In addition, create 3 additional tables that could be consistent in a database for a human resources(HR) application,including an appropriate table name and appropriate columns.

Create and submit a screenshot of your database diagram based on the tables, and generate the data definition language (DDL) for each table.

Submit a consolidated Word document with the screenshot and the DDL for all tables (text only, no screenshots).

Reference no: EM13192554

Questions Cloud

Define solution containing the thiourea complex of bismuth : A solution containing the thiourea complex of bismuth (III) has a molar absorptivity of 9.32*10^3 l/mol*cm at a wavelength of 470 nm

Southern states adopted the northern system : Southern states adopted the northern system of

Explain the reaction of hydrochloric acid : write out the balanced net ionic equation for the reaction of hydrochloric acid

Define copper iodate precipitates from iodate solution : Copper(II) iodate precipitates from iodate solution. The formula of the precipitate is CU(IO3)2. A saturated solution of this substance was made in 0.01 M KIO3.

Submit a consolidated word document with the diagram : Create and submit a screenshot of your database diagram based on the tables, and generate the data definition language (DDL) for each table.

What are the seasons like on our planet : Smekz is a planet whose rotation axis is NOT tilted with respect to its orbital plane. What are the seasons like on our planet?

Calculate the change in internal energy when co converted : calculate the change in internal energy when 2 moles of CO are converted to 2 moles of CO2 at 1 bar and 25 degrees C

Find the crews rowing rate in still water : A boat's crew rowed 12 miles downstream, with the current, in 1.5 hours. The return trip upstream, against the current, covered the same distance, but took 4 hours. Find the crew's rowing rate in still water and the rate of the current.

Describe how quadratic equations are important : describe how quadratic equations are important to a basketball player or a sniper. And give a real world example.

User Account

All Pages