1. Consider the following scenario: an IT department at a large company must keep information about workstations deployed throughout the company. For each workstation, the following information must be kept
: ◦ inventory number (This is uniquely assignment by the IT department to each workstation it purchases and is etched onto the workstation.)
◦ product serial number (This is uniquely assigned by the workstation vendor and is on a panel in the rear of the workstation.
Serial numbers of different vendors may overlap; that is, workstations of two different vendors could have the same serial number.)
◦ workstation vendor (This is the name of the vendor of the workstation. All vendors have different names.)
◦ date purchased
◦ purchase price
◦ amount of RAM
◦ size of disk storage
◦ Solid state drive or hard drive
◦ location (A room number, which is a three digit number.)
a. Write a a relational table schema for this information. Include a table name along with the column names and column domains as part of your schema. Use this format: Table_name(col1: domain1; col2:domain2: … ; coln:domainn)
b. Which column or set of columns can be used to uniquely identify the tuples in the table? Use this information to identify the candidate keys for the table.
c. Identify all of the super keys derived from the candidate keys from part b.
d. Identify the one primary key and any alternate keys from the candidate keys from part b.
NOTE: PLEASE PROVIDE ME THE ANSWERS FOR a, b, c, d
