Design a Relational Database Design a relational database with information on three of the most popular smart phone service providers: AT&T T-Mobile Sprint Create a database using Microsoft Access to store and manage this information. Save the database as SmartPhoneProviders. Name the table for AT&T the ATTTable, the table for T-Mobile the TMobTable, and the table for Sprint the SprintTable. Design for Tables AT&T T-Mobile Sprint Fields in each table: PlanType Price Contract? Data Type: Short text Currency Short text Designate the field, PlanType as the primary key field in this table. Add the following records to the ATTTable: PlanType Price Contract? ATT Plan A $39.99 Yes ATT Plan B $49.99 Yes ATT Plan C $59.99 No ATT Plan D $69.95 No ATT Plan F $79.95 No Add the following records to the TMobTable PlanType Price Contract? TMob Plan 15 $39.50 Yes TMob Plan 25 $49.50 Yes TMob Plan 40 $59.55 Yes TMob Plan 50 $69.50 Yes TMob Plan 65 $79.55 Yes Add the following records to the

Trusted by Students Everywhere

Human-written only.

Anytime, anywhere.

100% Original.

Masters & PhDs.

Your privacy matters.

Never miss a deadline.

Design a Relational Database Design a relational database with information on three of the most popular smart phone service providers: AT&T T-Mobile Sprint Create a database using Microsoft Access to store and manage this information

Computer Science Sep 15, 2021

Design a relational database with information on three of the most popular smart phone service providers:

Create a database using Microsoft Access to store and manage this information.
Save the database as SmartPhoneProviders.
Name the table for AT&T the ATTTable, the table for T-Mobile the TMobTable, and the table for Sprint the SprintTable.

Designate the field, PlanType as the primary key field in this table. Add the following records to the ATTTable:

Add the following records to the TMobTable

Add the following records to the SprintTable:

Create one form for each table.
Create one report for all three tables.
Create a query that indicates which company has a plan price that is greater than or equal to $69.95, and does not require a contract.