Unit 3 Database
mandrak_inglesGiven the following sample database diagram, do the following:
- Create the needed tables in the SQL server environment (just tables, no relationships yet).
- Use integer (INT) data types for all ID columns.
- Hire_Date, Start_Date, and End_Date should all be DATE data types.
- Salary and Commission_Pct 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 screenshot and the DDL for all tables (text only, no screenshots).
- 10 years ago
- 10
Answer(3)
Purchase the answer to view it
NOT RATED
- database_assignment_unit3_.doc
- database_assinment_unit_3.doc
Purchase the answer to view it
NOT RATED
- unit3.docx
Purchase the answer to view it
NOT RATED
- sql_server_environment.docx
Bids(1)
other Questions(10)
- magerial apps of info techngy
- ECO 372 Week 1-5 DQs
- econ utility question
- E16-2B (Conversion of Bonds) Telta Inc. issued $15,000,000 of 12%, 40-year convertible bonds on November 1, 2014, at 97 plus accrued interest. The bonds were dated July 1, 2014, with interest payable January 1 and July 1. Bond discount (premium) is amorti
- Operations Management IP4
- Endangered Species - Gen Boiology
- Tax Accounting- Multiple Choice
- 6 pages
- inf342 project quality
- Project