Assignment: Physical Design
You created your database in the SQL server you were provided within your lab environment and translated this design into SQL server tables with appropriate fields. Select the appropriate data type for every field. The specific data type you select will depend on the size and range of the values that will be stored in the field.
Specify all primary keys as "identity" fields, and not as auto-increment.
After creating the tables, use the "insert" command to populate the tables with sample data for all the tables. (This will be affirmed in your SQL server in the lab environment.)
Data Retrieval
Provide select statements to satisfy the following data requests.
a. List all available laptops assigned laptops to managers.
b. List all available named licenses.
c. List the workstations that are over three years old (from the date of purchase) and assigned to leads.
d. List the name of the leads, workstation IDs, and location.
e. List the names of all the leads in the operations department.
f. List all the workstations with an amount of disk space less that the average disk space available in all workstations.
g. List the names of all managers with employees who have not been assigned a workstation.
Include screen shots of the SQL statements used to perform each step as well as the result sets resulting from the execution of the SQL statements. Describe what you did to complete each step.
Format your assignment according to the give formatting requirements:
a. The answer must be double spaced, typed, using Times New Roman font (size 12), with one-inch margins on all sides.
b. The response also includes a cover page containing the title of the assignment, the course title, the student's name, and the date. The cover page is not included in the required page length.
c. Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.