Review the tracks table. Identify the key and which attributes are fully dependent on the key. Support your answer.

 

Transcribed Image Text:

$ SQLITE TUTORIAL media_types MediaTypeld: INTEGER Name: NVARCHAR(120) genres Genreld: INTEGER Name: NVARCHAR(120) playlists Playlistid INTEGER Name: NVARCHAR(120) playlist_track Playlistid: INTEGER Trackld: INTEGER tracks Trackid INTEGER Name: NVARCHAR(200) Albumid. INTEGER MediaTypeid: INTEGER Genreld INTEGER Composer: NVARCHAR(220) Milliseconds INTEGER Bytes. INTEGER UnitPrice NUMERIC artists Artistid INTEGER Name: NVARCHAR(120) invoices Invoiceld: INTEGER Customerid: INTEGER InvoiceDate: DATETIME BillingAddress: NVAR... BillingCity: NVARCHA... 4 more columns..... invoice_items Invoiceltemid: INTEGER Invoiceld: INTEGER Trackid INTEGER UnitPrice: NUMERIC Quantity: INTEGER albums Albumid: INTEGER Title: NVARCHAR(160) Artistid: INTEGER customers Customerid INTEGER FirstName: NVARCHAR(40) LastName NVARCHAR(20) Company NVARCHAR(80) Address: NVARCHAR(70) City NVARCHAR(40) State NVARCHAR(40) Country: NVARCHAR(40) PostalCode: NVARCHAR(10) Phone: NVARCHAR(24) Fax NVARCHAR(24) Email: NVARCHAR(60) SupportRepld INTEGER employees Employeeld: INTEGER LastName: NVARCHAR(20) FirstName: NVARCHAR(20) Title: NVARCHAR(30) Reports To INTEGER BirthDate DATETIME HireDate: DATETIME Address: NVARCHAR(70) 7 more columns... $ SQLITE TUTORIAL media_types MediaTypeld: INTEGER Name: NVARCHAR(120) genres Genreld: INTEGER Name: NVARCHAR(120) playlists Playlistid INTEGER Name: NVARCHAR(120) playlist_track Playlistid: INTEGER Trackld: INTEGER tracks Trackid INTEGER Name: NVARCHAR(200) Albumid. INTEGER MediaTypeid: INTEGER Genreld INTEGER Composer: NVARCHAR(220) Milliseconds INTEGER Bytes. INTEGER UnitPrice NUMERIC artists Artistid INTEGER Name: NVARCHAR(120) invoices Invoiceld: INTEGER Customerid: INTEGER InvoiceDate: DATETIME BillingAddress: NVAR... BillingCity: NVARCHA... 4 more columns..... invoice_items Invoiceltemid: INTEGER Invoiceld: INTEGER Trackid INTEGER UnitPrice: NUMERIC Quantity: INTEGER albums Albumid: INTEGER Title: NVARCHAR(160) Artistid: INTEGER customers Customerid INTEGER FirstName: NVARCHAR(40) LastName NVARCHAR(20) Company NVARCHAR(80) Address: NVARCHAR(70) City NVARCHAR(40) State NVARCHAR(40) Country: NVARCHAR(40) PostalCode: NVARCHAR(10) Phone: NVARCHAR(24) Fax NVARCHAR(24) Email: NVARCHAR(60) SupportRepld INTEGER employees Employeeld: INTEGER LastName: NVARCHAR(20) FirstName: NVARCHAR(20) Title: NVARCHAR(30) Reports To INTEGER BirthDate DATETIME HireDate: DATETIME Address: NVARCHAR(70) 7 more columns...

Answer rating: 100% (QA)

A key is a unique identifier for a row in a database Keys are necessary for a database because they ... View the full answer