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

Internet Trends and Emerging Technologies

 Seek out the latest presentation by Mary Meeker on “Internet Trends” (if you cannot find it, the video from 2019 is available at https://www.youtube.com/watch?v=G_dwZB5h56E or seek out another source of information on Internet Trends and Emerging Technologies . Write 1 page describing what the top three trends and/or emerging technologies are, in your opinion and why.  Are there any ethical dilemmas over those trends and why? (Think about printable like 3D printers and weapons, autonomous vehicles, wearables, findables, etc...).  In your opinion, is this trend good for mankind? WE HAVE DONE THIS ASSIGNMENT BEFORE, WE CAN ALSO DO IT FOR YOU GET SOLUTION FOR THIS ASSIGNMENT,  Get Impressive Scores in Your Class CLICK HERE TO MAKE YOUR ORDER   on  Internet Trends and Emerging Technologies Are You looking for Assignment and Homework Writing help?  We Provide High-Quality Academic Papers at Affordable Rates. No Plagiarism. TO BE R...
1 comment
Read more