Question: 1. a. Create a type called phone number meant to store phone numbers. The type will have three pieces: areacode, officecode, linenumber. (i.e., a phone
1. a. Create a type called phone number meant to store phone numbers. The type will have three pieces: areacode, officecode, linenumber. (i.e., a phone number like 518- 454-2105 has an areacode of 518, an officecode of 454 and a linenumber of 2105). b. Create a table called directory, having three columns, firstname (text), cell (phonenumber), and age (int). C. Insert two rows into the table (one row with the area code 518 one row witha different area code). d. Write a query that finds all rows with the area code 518 (i.e, select * from directory where..)
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
