Find Jobs
Hire Freelancers

Database Applications

$2-8 USD / hour

Terminado
Publicado hace casi 9 años

$2-8 USD / hour

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.
ID del proyecto: 7395995

Información sobre el proyecto

7 propuestas
Proyecto remoto
Activo hace 9 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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. Thanks
$4 USD en 10 días
5,0 (4 comentarios)
2,4
2,4
7 freelancers están ofertando un promedio de $9 USD /hora por este trabajo
Avatar del usuario
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 en 5 días
5,0 (9 comentarios)
4,0
4,0
Avatar del usuario
5 year experience in developing and design database systems. Work with Oracle,Microsoft SQL,PostgreSQL,SqlLite Start work as freelencer.
$5 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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, DEVEXPRESS, SPREADSHEET TOOLS in my development.
$7 USD en 21 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de MALAYSIA
Petaling Jaya, Malaysia
4,8
22
Forma de pago verificada
Miembro desde nov 7, 2014

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.