3) Using the following image below, create a list of each of the column variable

Question

3) 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. DatePaid 11/10/2016 Name Bill Bob 412-422-1454 Jane Smith 724-525-8915 Hank Azeria 814-902-0178 Glen Coco 814-901-5818 PhoneNumber Amountowed Paid 25 Y 72 No 99.99 N 110 N 4) 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. IST 110-Information, People and Technology Class Section 12628 001-LEC Days & Times TuTh 9:05AM 10:20AM Room Meeting Dates Status Jessica Kropczynski 01/09/2017- 04/28/2017 IST Bldg 113 Reqular Class Section Meeting Dates Days & Times MoWe 4:00PM Room Instructor Status 01/09/2017- 04/28/2017 IST Bldg 113 Alison Murphy 12807 002-LEC Reqular 5:15PM Class Section Meeting Dates Status Days & Times MoWeFr 10:10AM 11:00AMM Room Instructor IST Bldg 210 James Reep 01/09/2017 - 04/28/2017 26210 003-LEC Class Section Days & Times Room Status TuTh 1:35PM 2:50PM Meeting Dates 01/09/2017- 04/28/2017 26218 004-LEC IST Bldg 210 Amy Garbrick Reqular

Explanation / Answer

Sql Data Types

3. Table --- Customer

4. Table --- Class

Name varchar(50) PhoneNumber varchar(20) AmountOwed decimal(7,2) Paid char(2) DatePaid date

Related Questions

Navigate

• Browse (All)
• Browse 3
• Subjects

---

---

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