1) Using the following image below, create a list of each of the column variable
ID: 3878112 • Letter: 1
Question
1) Using the following image below, create a list of each of the column variables that would be created if this would be implemented in a database. Be sure to provide data types and lengths for each of these variables. Image Plays Year 2015 Size 3:27 7.4 MB 2:58 2.8 MB 4:09 8.4 MB 3:30 7.3 MB 4:19 8.8 MB 3:26 7 MB :14 8.5 MB 3:30 7.2 MB Artist AName 4)·No Way Out (feat. Kat Nestel Vicetone 2 Pierce Fulton Kuaga (Lost Time) Pierce Fulton Spinnin Records Be... Dance Majical Cloudz Party Favor Elie Goulding Galantis & Hook N... Love on Me- Single Dance Nari & Milani & So... Mighty Game-Sin.... Dance 3LAU 2015 2016 2014 2016 1 2016 3 2014 Are You Alone? Party & Destroy-E Goodness Gracious... Pop Ku) 4In My Head (feat. Georgia 5 Goodness Gracious (The Chains Love on Me Mighty Game How You Love Me (feat. Bright Li… How You Love Me (.. Electronic 2) Using the following image below, create a list of each of the column variables that would be created if this would be implemented in a database. Be sure to provide data types and lengths for each of these variables. Name Bill Bob Jane Smith 4552 Smallridge Circle Hank Azeria 1579 Hillcrest Lane Glen Coco 462 Applewood Drive Address 222 Clowncar Road AmountOwed Paid 25.87 Y 184.12 N 99.99 N 389.47 NExplanation / Answer
1 Table ---- Song
2)Table Customer
Name varchar(200) Artist varchar(100) Album varchar(200) Genre varchar(50) Plays smallint Year int Time time Size varchar(20)Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.