Skip to main content

You will now create a database for the following seven tables. You will build upon this database in the upcoming units of the course. Create a database containing the following tables: Table Department DepartmentID Name GroupName ModifiedDate Table Employee EmployeeID

You will now create a database for the following seven tables. You will build upon this database in the upcoming units of the course.

Create a database containing the following tables:

Table Department


DepartmentID
Name
GroupName
ModifiedDate

Table Employee


EmployeeID
NationalIDNumber
ContactID
LoginID
ManagerID
ShiftID
Title
BirthDate
MaritalStatus
Gender
HireDate
SalariedFlag
VacationHours
SickLeaveHours
CurrentFlag
rowguid
ModifiedDate

Table EmployeeAddress


EmployeeID
AddressID
rowguid
ModifiedDate

Table EmployeePayHistory


EmployeeID
RateChangeDate
Rate
PayFrequency
ModifiedDate

Table EmployeeDepartmentHistory


EmployeeID
DepartmentID
StartDate
ShiftID
EndDate
ModifiedDate

Table Shift


ShiftID
Name
StartTime
EndTime
ModifiedDate

Table JobCandidate


JobCandidateID
EmployeeID
Resume
ModifiedDate
•Create the needed tables in the SQL server environment (just tables, no relationships yet). ◦Use integer (INT) data types for all ID columns.
◦Use DATE data types for all date-related columns.
◦Rate related columns 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 diagram and the DDL for all tables.                  

Comments

Post a Comment

Popular posts from this blog

Identify and discuss a key milestone in the history of computers that interests you and why.

  Part 1Title: Lab ResponseDiscuss one feature of MS Word and one feature of MS Excel that you found challenging within the lab and why. Examples are WordArt, inserting shapes, adding borders, cell styles, etc. This response should be at least one paragraph in length. Part 2Title: History of Computers Identify and discuss a key milestone in the history of computers that interests you and why. This section should be at least one paragraph. Part 3Title: System Software vs. Application Software In your words, explain the difference between application software and system software as if to another coworker who has limited technical knowledge. Use examples to support your rationalization. This section should be at least two paragraphs. Part 4Title: Blockchain and Cryptocurrency In a minimum of one paragraph each: 1. Conduct some research on the internet and discuss one underlying technology of cryptocurrencies like blockchain, cryptography, distributed ledger technol...
Post a Comment
Read more

Cybersecurity and Infrastructure Security (CISA)

 Develop a research paper that identifies a specific Department of Homeland Security (DHS) operating agency. Fully describe 1 DHS operating agency from the following list: Cybersecurity and Infrastructure Security (CISA) U.S. Customs and Border Protection (CBP) U.S. Citizenship and Immigration Services (USCIS) Federal Emergency Management Agency (FEMA) U.S. Coast Guard (USCG) U.S. Immigration and Customs Enforcement (ICE) U.S. Secret Service (USSS) Transportation Security Administration (TSA) The information must include a discussion of the selected DHS agency. Identify the agency’s mission, goals, objectives, and metrics. Conduct an analysis of how these mission areas address the threats or challenges. Recommend agency program priorities among the current set of goals, objectives, metrics, or budget items. Justification of all choices is an essential element of this assignment. Reference all source material and citations using APA format. WE OFF...
Post a Comment
Read more

You have been given the t

PPMP20009 Leading Lean Projects Term 2, 2018 Page 1 of 3 Assessment 1 (Individual Work – 40%) Case study: Managing Lean Project Introduction You have been given the task to organise the FIFA 2018 World Cup football tournament ( https://ift.tt/2If0UDE ). (For those not familiar with football, you may change the event to the recently concluded 2018 Gold Coast Commonwealth Games: https://gc2018.com/ ). Your tasks This assessment item requires you to work INDIVIDUALLY. 1. As the project manager in charge of delivering such as an important world sporting event: i. Identify and elaborate the following terms with regards to the event. a. Voice of the Customer (VOC) b. Critical to Customer Requirements (CCR) c. Critical to Quality parameters (CTQ) ii. In what ways would you have implemented lean project management for this event? Identify and elaborate processes from PMBOK, PRINCE2, Organisational Project iii. Management Agile Practices and Lean Six Sigma (DMAIC Me...
Post a Comment
Read more