Given the following sample database diagram do the

Assignment Help Database Management System

Reference no: EM13380346

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: EM13380346

Questions Cloud

The big state university course catalog reads as follows to : the big state university course catalog reads as follows to enroll in mis 260 which is an advanced course a student

Kitchen gadgets sells a line of high-quality kitchen : kitchen gadgets sells a line of high-quality kitchen utensils and gadgets. when customers place orders on the companys

1 character strings in c and c are implemented as arrays : 1. character strings in c and c are implemented as arrays ofnbspchar. these arrays can be initialized to string

Backgroundjulia and robert have made progress in the : backgroundjulia and robert have made progress in the development of a strategic plan for kahuna cleaning supply. robert

Given the following sample database diagram do the : given the following sample database diagram do the followingcreate the needed tables in the sql server environment just

Part 1in your own words answer the following questionswhat : part 1in your own words answer the following questionswhat is network infrastructure management? what are the

Project 1 bull in your own words what rfc gives : project 1 bull in your own words what rfc gives the protocol and specifications a news server must use to

The australian commonwealth government has developed a : the australian commonwealth government has developed a cloud computing strategy and cloud computing policy and you as

You have no guarantees about the accuracy of the input from : you have no guarantees about the accuracy of the input from the user. you have to check all input and give helpful

User Account

All Pages