1. Open SQL Microsoft SQL Management Studio. 2. Create a database named DB_CompanyX. 3. Create tables for the database. See Table 1 for the table name, column name, and data type. Table 1. Creating Tables Table Name Column Data Type EMPLOYEE_NO *primary key* BIGINT BIRTH_DATE DATE FIRST_NAME VARCHAR (50) TBL_EMPLOYEE LAST_NAME VARCHAR (50) GENDER VARCHAR HIRE DATE DATE EMPLOYEE_NO *foreign key* BIGINT TITLE VARCHAR (50) TBL_EMP_TITLE FROM_DATE DATE TO_DATE DATE EMPLOYEE_NO *foreign key* BIGINT SALARY INT TBL_EMP_SALARY FROM_DATE DATE TO_DATE DATE EMPLOYEE_NO *foreign key* BIGINT DEPARTMENT_NO *foreign key* CHAR (10) TBL_DEPT_EMP FROM DATE DATE то DATE DATE Task Performance 1 *Property of STI Page 1 of 2 ESTI IT1924 DEPARTMENT_NO *primary key* CHAR (10) TBL_DEPARTMENTS DEPARTMENT_NAME VARCHAR (40) DEPARTMENT_NO *foreign key* CНAR (10) EMPLOYEE_NO *foreign key* BIGINT TBL_DEPARTMENT_MANAGER FROM_DATE DATE TO_DATE DATE 4. Create a database diagram and indude all the tables. 5. Using PowerPoint shapes, illustrate the relationship of each table based on the given output of the diagram. 6. Save the word file as TP_LastName_FirstName_DB_CompanyX.

1. Open SQL Microsoft SQL Management Studio. 2. Create a database named DB_CompanyX. 3. Create tables for the database. See Table 1 for the table name, column name, and data type. Table 1. Creating Tables Table Name Column Data Type EMPLOYEE_NO primary key BIGINT BIRTH_DATE DATE FIRST_NAME VARCHAR (50) TBL_EMPLOYEE LAST_NAME VARCHAR (50) GENDER VARCHAR HIRE DATE DATE EMPLOYEE_NO foreign key BIGINT TITLE VARCHAR (50) TBL_EMP_TITLE FROM_DATE DATE TO_DATE DATE EMPLOYEE_NO foreign key BIGINT SALARY INT TBL_EMP_SALARY FROM_DATE DATE TO_DATE DATE EMPLOYEE_NO foreign key BIGINT DEPARTMENT_NO foreign key CHAR (10) TBL_DEPT_EMP FROM DATE DATE то DATE DATE Task Performance 1 Property of STI Page 1 of 2 ESTI IT1924 DEPARTMENT_NO primary key* CHAR (10) TBL_DEPARTMENTS DEPARTMENT_NAME VARCHAR (40) DEPARTMENT_NO foreign key CНAR (10) EMPLOYEE_NO foreign key BIGINT TBL_DEPARTMENT_MANAGER FROM_DATE DATE TO_DATE DATE 4. Create a database diagram and indude all the tables. 5. Using PowerPoint shapes, illustrate the relationship of each table based on the given output of the diagram. 6. Save the word file as TP_LastName_FirstName_DB_CompanyX.

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Q: Given the default schema of a database: EB Orders 123 Orderld OrderDate ADC OrderNumber 123…

A: The question has been answered in step2

Q: Having this information. Students Attribute Name Data Type StudentID char(11) FirstName varchar(20)…

A: Structured Query Language, abbreviated as SQL, which refers to the one it is a domain-specific…

Q: database with Howing BUIMOTTO Table: Employees | Column Name 1 Туре I id | int | varchar I I name…

A: The SQL queried is given below.

Q: 6. Write a SQL statement to create a simple table named teams including columns team_id int,…

A: Given:

Q: Using the types of entities database attached (trips, guides, customers, and reservations), create…

A: Trip_No Trip_Dt Trip_Dest Trip_Price Guide_Name Guide_Phone Cust_Name Cust_Phone…

Q: Create a View to show the city name of any location that has a department. Only show the city name…

A: Introduction: A SQL database, often known as a relational database, is made up of a number of highly…

Q: Having this information. Students Attribute Name Data Type StudentID char(11) FirstName varchar(20)…

A: 1. The MySQL code for the given problem is as follows: CREATE TABLE Students ( StudentID…

Q: Please convert following figure into a relational schema. In each table, the primary key and foreign…

A: Here the entity BankBranch is a weak entity and therefore we need to include primary key of Bank as…

Q: REQUIREMENTS TABLE: Field Name Data type Field size Constraints Content / Description REQUESTS…

A: The Staff and Admin has many attributes common and hence it seems Admin is sub-type of Staff entity…

Q: Write a query to create the zoo database. Write queries to create the tables. Be sure to include…

A: Note: Here, we can't able to share SQL script files to execute directly on the database. Bartleby is…

Q: L script which is the physical design for this database ### Animals This table contains the…

A: Note: As per the Bartleby policy we can solve only one question at a time. Please repost the…

Q: The Car Maintenance team considered that the available maintenance tasks should also have the price…

A: TASK 1: -- Creating a new table MAINTENANCE_TYPES with following fields create table…

Q: Convert the following ER diagram into a relational database schema, be certain to indicate primary…

Q: SQL Help The Car Maintenance team wants to learn how many times each car is used in every month and…

A: In order to perform the given query, consider a sample database with the name CARMAINTAINENCE where,…

Q: Branch Table Column Name BR_ID Data Type NUMBER FK Description Each Branch will have a Unique Size…

A: Note: 1. we had make sure that foreign key at child table data type matches with parent table data…

Question

1. Open SQL Microsoft SQL Management Studio.
2. Create a database named DB_CompanyX.
3. Create tables for the database. See Table 1 for the table name, column name, and data type.
Table 1. Creating Tables
Table Name
Data Type
Column
EMPLOYEE_NO *primary key*
BIGINT
BIRTH_DATE
DATE
FIRST_NAME
VARCHAR (50)
TBL_EMPLOYEE
LAST_NAME
VARCHAR (50)
GENDER
VARCHAR
HIRE_DATE
DATE
EMPLOYEE_NO *foreign key*
BIGINT
TITLE
VARCHAR (50)
TBL_EMP_TITLE
FROM_DATE
DATE
TO_DATE
DATE
EMPLOYEE_NO *foreign key*
BIGINT
SALARY
INT
TBL_EMP_SALARY
FROM_DATE
DATE
TO_DATE
DATE
EMPLOYEE_NO *foreign key*
BIGINT
DEPARTMENT_NO *foreign key*
CHAR (10)
TBL_DEPT_EMP
FROM_DATE
DATE
TO_DATE
DATE
02 Task Performance 1
*Property of STI
Page 1 of 2
STI
IT1924
DEPARTMENT_NO *primary key*
CHAR (10)
TBL_DEPARTMENTS
DEPARTMENT_NAME
VARCHAR (40)
DEPARTMENT_NO *foreign key*
CHAR (10)
EMPLOYEE_NO *foreign key*
BIGINT
TBL_DEPARTMENT_MANAGER
FROM_DATE
DATE
TO_DATE
DATE
4. Create a database diagram and include all the tables.
5. Using PowerPoint shapes, illustrate the relationship of each table based on the given output of the
diagram.
6. Save the word file as TP_LastName_FirstName_DB_CompanyX.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Similar questions

Find the names of the pilots who are not certified to fly the aircrafts in the flight table. Sort the name by ascending order.
Thank you for helping! Write the SQL code to produce the total number of hours and charges for each of the projects represented in the ASSIGNMENT table. The result is shown as below. Write the SQL code to display the information of employees who are working as either programmer or system analyst. Write the SQL code to produce job_descriptions(job_title) of employees who are working at project ‘Evergreen’.
Topic: Database Software: SQLite Schema Table: CREATE TABLE name_basics (nconst VARCHAR(45) NOT NULL, primaryName VARCHAR(45) NULL, birthYear YEAR(4) NULL, deathYear YEAR(4) NULL, age INT NULL, movieNum INT NULL, PRIMARY KEY (nconst)); CREATE TABLE attributes (attributeID INT NOT NULL,attribute VARCHAR(45) NOT NULL,PRIMARY KEY (attributeID)); CREATE TABLE attributes_collection (akasID INT NOT NULL,attributeID INT NOT NULL,PRIMARY KEY (akasID, attributeID),CONSTRAINT attributeIDFOREIGN KEY (attributeID)REFERENCES attributes (attributeID)ON DELETE NO ACTIONON UPDATE NO ACTION);CREATE TABLE crew_directors (crewID INT NOT NULL,nconst VARCHAR(45) NOT NULL,PRIMARY KEY (crewID, nconst),CONSTRAINT crewIDFOREIGN KEY (crewID)REFERENCES title_crew (crewID)ON DELETE NO ACTIONON UPDATE NO ACTION,CONSTRAINT nconstFOREIGN KEY (nconst)REFERENCES name_basics (nconst)ON DELETE NO ACTIONON UPDATE NO ACTION);CREATE TABLE crew_writers (crewID INT NOT NULL,nconst VARCHAR(45) NOT NULL,PRIMARY KEY…
Given the following schema, answer the following questions USERS Attribute Data Type USER_ID NUMBER(3) USER_NAME VARCHAR2(20) USER_TYPE VARCHAR2(10) USER_LIMIT NUMBER(1) BOOKS Attribute Data Type BOOK_ID NUMBER(5) BOOK_TITLE VARCHAR2(25) BOOK_YEAR VARCHAR2(4) Write the SQL code that will create the tables structures for the tables named Books, and Users. Identify and include any PK and FK for both tables.
Based on the ERD below, write the SQL statement to change the job description of “Database Designer” to “Database Developer”. After completing this task examine the results with a select statement. (Hint: Use an Update Statement.)