Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

based off the physical design above, answer the following questions in SQL How many customers live in Texas? How much does Extra Service X(gift card)

based off the physical design above, answer the following questions in SQL image text in transcribed

How many customers live in Texas?

How much does Extra Service X(gift card) cost?

How many customers have TV package A?

What state uses the most extra services?

How many Bills are associated with each customer?

How many states do Comcast customers live in?

Which state has the most bills?

How many TV packages are available through Single Service Pricing?

How many Internet packages are available through Single Service Pricing?

How many cities do Comcast customers live in?

Single Service Pricing Bundle Bund eID INT Property City VARCHAR(15 Phone Phone!D VARCHAR(5) TVMD VARCHARE) Duration INT Property ZIP VARCHARIS Bunde A BundielD INT Bunde -Bundlel0 NT Bundle A Bundle Phone First Name VARCHAR20) Last Name VARCHAR(45) Address VARCHAR(45) City VARCHAR15) State VARCHAR 2 ZIP VARCHARS Phone VARHARi1 TV TVID INT Channels INT Free-HD DECIMAL(1) Prico DECIMAL/10.2) InternetID INT Price DECIMAL 10,2 1024) | | Bill Bling Dae DATETIME Due Dae DATET ME Amout DECIMAL 10,2) BI Start Date DATETME End Cate CATETIME Bundle BundlelD INT NT Contract ContractlD1 BIl Contrsct ContraMID INT ? Single Service Pricing-SnglaserviDelD VARCHAR(18 Extra TypelD Extra Services TypelD VARCHAR11

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design Using Entity Relationship Diagrams

Authors: Sikha Saha Bagui, Richard Walsh Earp

3rd Edition

103201718X, 978-1032017181

More Books

Students also viewed these Databases questions

Question

What is BAC? AppendixLO1

Answered: 1 week ago