Small Database Project

Develop the queries to support each of the reports that are required by Ms Smith. It is expected that the information returned by the queries is adequate to be used in the reporting process. Make sure your output contains enough information! The following is a recommendation and the MINIMUM amount of data you should have access to:

* Customer Table: A minimum of 12 customers (this will allow several channels to have more than one customer selecting it as a favorite channel)

* Billing Table: Records to support the above customers

* Program Table: A minimum of 25 programs (your program guide should have enough programs for various channels to support the program guide report)

* Other tables: A sufficient amount of data to support the above when reports are run

Show each query and its output in your submission (you will have a minimum of six queries).

To submit this task, create a heading REPORTING STATEMENTS in the SQL document and create a spooled or HTML output of your queries and the result set for each.

Attached are the Tables and insert statements

Budget: $20 USD

Skills: SQL

See more: java database small project, java small project database, sql database small project, mysql, sql, microsoft sql server, database development, database programming, query project database, small project database sql, database small project, database small project access, query ms project database, asp net small project database, small project database, show query results website, project database hotel, real estate project database, php mysql simple project database, project database online quiz

About the Employer:
( 0 reviews ) United States

Project ID: #11738153

30 freelancers are bidding on average $139 for this job


My name is Manh from Vietnam. I read your project details and I am sure I can complete your [login to view URL] we can chat/discuss further on your project?

$30 USD in 1 day
(37 Reviews)

Hi there, I would like to do this project if given the opportunity. Let me know if you are interested so I can have further details. Thanks.

$30 USD in 1 day
(46 Reviews)

I am sql expert certified by Oracle corporation

$55 USD in 1 day
(18 Reviews)

I am having more than 7 years of experience in IT industry.I have worked on .net(c#,asp,,mvc) with sql server 2005/2008/2012 and oracle(pl/sql). I can provide you better solution by utilizing my knowledge and More

$250 USD in 5 days
(4 Reviews)

Hello, I am interested in your project. I am a software engineer and I have professional experience with SQL. Could you please send me more details about your project? Thank you, Best regards, David

$150 USD in 5 days
(15 Reviews)

Hi Dear I have a lot of experience in DataBases ,Data Warehous,DB2 , Teradata etc . I am DataBases + Warehouse certified from Oracle,postgresSQL,SQL SERVER , Access. I have done many work in Requirements analysis , Da More

$155 USD in 3 days
(9 Reviews)

Please review my profile. I have 4 years experience in SSRS, SSIS and 6.9 years experience in SQL. Please let me know more details and when will we start. Skype: jikenjd

$30 USD in 0 days
(6 Reviews)
$300 USD in 10 days
(1 Review)
$155 USD in 3 days
(4 Reviews)

Hi, I've over viewed the details of the project provided by you and I am please to declare myself the right candidate for this project as I've completed many successful projects in PHP and it's frameworks like laravell More

$194 USD in 3 days
(2 Reviews)

I can do.

$120 USD in 5 days
(1 Review)

Hi Madam/Sir, I am expert in SQL. I have been working databases -Oracle/Teradata/DB2/Sybase/MYSQL/Vertica. Let us have detailed discussion and plan to ensure smooth delivery of the project. Thanks and Regards, More

$235 USD in 5 days
(0 Reviews)

Hi there, I’d like to be considered for this project. I’m a software developer with a strong background developing projects like All Lines Insurance Suits, Online Shopping, Library Management System, WCF services for More

$277 USD in 5 days
(0 Reviews)

I am Microsoft SQL Programmer and i have very good real time experience and i am very good at ->Designing and deploying data table structures, forms, reports, and queries. ->Identifying inefficiencies in current da More

$103 USD in 4 days
(0 Reviews)

Playing with SQL is my day to day work.

$88 USD in 2 days
(0 Reviews)

I have an experience of 12 years in Oracle, SQL database with reporting tools like Business Objects, crystal reports . I have also worked as a database Architecture. I think i can give full justice to your projects.

$155 USD in 3 days
(0 Reviews)

Hello My name is Pranav I have checked the details shared by you will do done exactly what you want Please consider my bid and we can discuss more so that i can assist you in better way our services always with More

$155 USD in 7 days
(1 Review)

Good experience in SQL. Certified database administrator. Experience in query optimization, performance tuning .

$166 USD in 5 days
(0 Reviews)
$166 USD in 3 days
(0 Reviews)
$250 USD in 5 days
(0 Reviews)