Homework answers / question archive / 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

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

Share With

---

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

1. Create a database using Microsoft Access to store and manage this information.
2. Save the database as SmartPhoneProviders.
3. 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 SprintTable:

PlanType	Price	Contract?
Sprint Plan A80	$39.99	No
Sprint Plan B80	$49.99	No
Sprint Plan C80	$59.99	No
Sprint Plan D80	$69.95	No
Sprint Plan F80	$79.95	No

 

4. Create one form for each table.
5. Create one report for all three tables.
6. 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.