computer science 2 1

Employing qualified writers in writing service like eliteresearchpapers.com is a fundamental step in ensuring that the work produced is of high quality. This not only benefits the students who use these services but also contributes to the credibility and reputation of the company in the academic community. One of the primary reasons for eliteresearchpapers.com employing qualified writers in academic writing services is their in-depth knowledge of the field. These writers typically hold advanced degrees in related disciplines, making them well-versed in the subject matter. Their expertise allows them to produce accurate, relevant, and insightful content that aligns with the academic standards. Qualified writers enable students to better manage their time. By outsourcing some of your academic writing tasks to eliteresearchpapers.com, you can allocate more time to other important aspects of you education, such as practice, internships, and studying for exams. This balanced approach contributes to a holistic learning experience.

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:

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

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).

 

 

MUST READ AND FOLLOW ALL INSTRUCTIONS IN THE SAMPLE,

 

MUST USE TEMPLATE

Eliteresearchpapers.com qualified writers are well-acquainted with the intricacies of academic writing. They are proficient in following the formatting, citation, and referencing guidelines specified by different institutions. This ensures that the work produced is not only academically sound but also meets the expectations of professors and professionals. Academic assignments often require critical analysis and evidence-based writing. Eliteresearchpapers.com qualified writers possess the skills to critically evaluate research, synthesize information, and present arguments backed by credible sources. This level of rigor is essential where evidence-based practice is paramount. When students receive well-researched and well-written assignments, they have the opportunity to learn from these examples. Eliteresearchpapers.com high-quality work serves as a valuable reference point for students, helping them understand complex concepts, research methodologies, and effective writing techniques.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.