After identifying the benefits that bringing a database to the table, the databa

Question

After identifying the benefits that bringing a database to the table, the database design phases need to identify which attributes that we would like to track and why we are tracking them. You shouldn’t track some because you can – you should track something because it has value. Value can be in terms of valuable to track or value to a process (i.e. report)

You are working at IT company as a data analyst. You are working on the database design for a system to assist the lock smith with key distribution on campus. You have identified several tables with a few attributes, but you are sure that there a few more attributes that could add value to the system

Tables with existing fields:

People (BannerID, FirstName, LastName)

Keys (KeyID)

KeyAssignment (BannerID, KeyID)

Discussion
In this discussion forum, you will identify an attribute that can be added to one of the tables that will add value to the database. You should identity the column, explain the benefits, and provide an example of the benefit.

Explanation / Answer

Ans:

---> Keys (KeyID,KeyType)

By using KeyType Attribute in keys Table we can find data like which person has which type of keys and vice versa. we can use Joins or sub queries to find this information.

sql-> select FirstName,LastName from People where exists(select BannerID from KeyAssignment wehere exists (select KeyID from Keys where KeyType=" "))

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

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