En curso

Database Applications

Requirements

Create a Schema, database and applications to support a GMC database system

Sample Applications

The following database queries are required to be displayed on screen (i.e. produce the SQL code only, no form or report). All queries must be completed with each student from the pair completing 3 out of 6 queries. Please list the queries implemented by each group member in the Performa so that final marks can be adjusted if necessary. If you opt to work alone then you must complete all 6 queries alone.

A1. A list of all stored titles, showing type of music and the number of all CDs within each type (i.e. Classic 50, Jazz 126, etc.).

A2. For any given member number, identify his/her address, method of purchase, and all CDs they have bought since a given date. This application is to run on-line (i.e. produce the output on the screen). The input parameter (the member unique number) should be input by the user at run-time.

A3. List the member’s full name and address, whose memberships are due for renewal. The calculation of the due date should be based on last year renewal date and the date of running the query (i.e. today’s date).

A4. For any given member, give the total amount he/she spent on orders since he/she joined the club. The input parameter (the member unique number) should be input by the user at run-time.

A5. For any given artist (e.g. singer), list all albums produced by that artist which is available in GMC stock. The name of the artist should be input by the user at run-time. Assume Artist name is unique within the system.

A6. List the most popular Artist’s details in terms of number of sales. Group this output in terms of member gender.

Habilidades: Entrada de datos, Procesamiento de datos, Redacción de informes, SQL, SQLite

Ver más: pair line, artist data, student database, on line artist, gmc , database system, database queries, database - student list, create data entry form sql, sql schema stock data, stock database schema, database system sql, database applications music database, list data entry applications, data input create report, create music database, database student, required sales database, can report system database, create database work orders, applications support, sql stock system, database output code, create database music, stock music

Información del empleador:
( 22 comentarios ) Petaling Jaya, Malaysia

ID de proyecto: #7395995

Adjudicado a:

boscha

Hi. I am professional database developer. I have experience here with similar projects. Please check my profile. My assumption: I will complete your requirements in one day. If you like my offer, feel free to contact. Más

$4 USD / hora
(1 comentario)
1.8

8 freelancers están ofertando un promedio de $10 /hora para este trabajo.

truongnguyen86

Hello there, thank you for inviting me to your project, pls share me your requirements and we will discuss. Waitin for your feedback. Thank you

$15 USD / hora
(89 comentarios)
5.9
fattahaabdul

i have 8+ years of experience. Can we discuss the project. Please initiate a chat with me so that we can discuss the project at a broader level. Why you should hire me- 1. I have a very good communication skills Más

$31 USD / hora
(2 comentarios)
4.1
ramehani

hi i have more than 7 years of experience in mysql development and willing to help you to complete your task in a quick and nice manner

$5 USD / hora
(6 comentarios)
3.7
TSkorvan

5 year experience in developing and design database systems. Work with Oracle,Microsoft SQL,PostgreSQL,SqlLite Start work as freelencer.

$5 USD / hora
(0 comentarios)
0.0
adilbangush

the task should be completed on time. need more information about the application type, and database type. having expensive experience on SQL SERVER, ACCESS, ORACLE and VISTADB databases. I am using VISUAL STUDIO, DEVE Más

$7 USD / hora
(0 comentarios)
0.0
techomaxsolution

Hi Sir, We have dedicated center running for Software development and BPO processes. We have experience resources on SQL,MYSQL,HTML5,Hadoop. We are very much interested in this [url removed, login to view] can test our capabilit Más

$5 USD / hora
(0 comentarios)
0.0
manishnagdew786

Hello Hiring Manager, Greetings of the day! I’m a Web Developer from India who is specialized in WP,Bootstrap,MS-Access,Database Management,SQL,Apache,HTML,CSS,AJAX,JSON,XML,Theme/Plugin Customization ,Responsi Más

$5 USD / hora
(0 comentarios)
0.0