1. Consider the following scenario: an IT department at a large company must kee

Question

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

Explanation / Answer

Question a)

Workstations ( Inventory_Number: Number(5), Serial_Number: Varchar2(16), Vendor: Varchar2(20), Purchase_Date: Date, Price: Number(10, 2), RAM: Number(3), Disk_Storage: Varchar2(10), SSD_HDD: Varchar2(10), Location: Number(3)

Question b)

To identify the tuples, the keys can be:

Inventory_Number

(Vendor, Serial_Number)

Question c)

All super keys that can be generated from part b,

Inventory_Number, Purchase_Date, Price, RAM, Disk_Storage, SSD_HDD, Location

Vendor, Serial_Number, Purchase_Date, Price, RAM, Disk_Storage, SSD_HDD, Location

Question d)

Primary key: Inventory_Number

Another Candidate key: (Vendor, Serial_Number)

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.