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

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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!