+1 (305 )-814-1214
+1 (305 )-814-1214 Toll-free
Log in
Log in
Order Now
All your Writing needs covered

Itco333 database | Computer Science homework help

Get a Price Order Now

Calculate the price
of
your order:

275 words
+ –
Approximate price
$ 0.00

Itco333 database | Computer Science homework help Create a SQL Server database called: ITCO333Database. Using Data Definition Language (DDL) and Data Manipulation Language (DML) you will create tables based on your Unit 1 ERD. In addition, you will create the below DEPARTMENTS and EMPLOYEES tables. Before you begin creating the new tables, review your tables created in Unit 1 IP to ensure that your database is in third normal form (3NF).   Part 1:   Your ITCO333 database should contain data related to the organizational departments in your Unit 1 chosen topic. Therefore, create a DEPARTMENTS table with the following field specifications: Field Name Data Type Other Comments and Requirements Department_ID int Primary Key Department_Name nvarcha(50)    Insert at least four records of sample data into the DEPARTMENTS table.   Your ITCO333 database should contain data related to employees in your Unit 1 chosen topic. Therefore, create an EMPLOYEES table with the following field specifications: Field Name Data Type Other Comments and Requirements Employee_ID Int Primary Key Last_Name nvarchar(50) Cannot be null. First_Name nvarchar(50) Cannot be null. Birth_Date datetime  Employment_Start_Date datetime  Hourly_Pay decia(p[,s]) Must be greater that 0 Department_ID Int Related to the DEPARTMENTS table. Create a foreign key constraint. Manager_ID Int Related to the Employee_ID in this table. Create a foreign key constraint. Insert at least eight records of sample data into the EMPLOYEES table. Part 2:   Using your Unit 1 ERD, create tables, fields, primary keys and relationship constraints in your ITCO333Database.   Insert your Unit 1 sample data into the newly created tables. Part 3:   Generate a SQL Server Database Diagram.   Additional Requirements:   All tables must be in Third Normal Form (3NF). This may require you to normalize your Unit 1 data. Be sure to incorporate Instructor feedback from your Unit 1 IP. Use the following data types: Integers: int Decimals: decimal(p[,s]) Strings: nvarchar(50) Date/Time: datetime    Deliverable: One Word document with:   SQL DDL to create database SQL DDL to create tables (including EMPLOYEES and DEPARTMENTS tables) SQL DML to insert data (including EMPLOYEES and DEPARTMENTS sample data) SQL Server Database Diagram    The aforementioned SQL DML must be in text format (no screen shots). 

«VPNEW»

Unlock your academic potential with Vintage-paper.com! Place your essay order today and experience top-notch writing services that guarantee academic success. Our expert writers are ready to craft customized papers that will exceed your expectations.Don't wait, order now and elevate your grades

Order Now

Basic features

  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support

On-demand options

  • Writer's samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading

Paper format

  • 275 words per page
  • 12pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, CHicago/Turabian, Havard)

Guaranteed originality

We guarantee 0% plagiarism! Our orders are custom made from scratch. Our team is dedicated to providing you academic papers with zero traces of plagiarism.

Affordable prices

We know how hard it is to pay the bills while being in college, which is why our rates are extremely affordable and within your budget. You will not find any other company that provides the same quality of work for such affordable prices.

Best experts

Our writer are the crème de la crème of the essay writing industry. They are highly qualified in their field of expertise and have extensive experience when it comes to research papers, term essays or any other academic assignment that you may be given!

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Check Prices
Order Now