We will create an application to manage the system of a cd shop.
Firstly we have the CD that might be a mix of singles or an album and is identified by an id, title, number of tracks, record company and description. A track has title, length, and the singer/s or band. A CD has at least 5 tracks.
This cd might belong to one single artist or a band. If a singer it is identified by an id, name, surname, nickname (if any) and if band it is identified by id and name.
CDs have Category that is identified by an id and description that includes genres of music (ex. alternative, rock, r&b, pop etc).
We have also a branches that are identified by an id, name, address, contact phone number and contact email.
Our shop has its own customers that are identified by id, name, surname, birthday, email.
In the database all CDs available is a branch shop are stored and number of copies. Moreover, for each customer we keep trace of the CD and the branch where he/she bought it.
Requirements are attached
Dear Customer, I have 7 years of experience as a software engineer. I am Oracle certified Database SQL Expert. I have experience in SQL dor DDL, DML and DCL. I have experience in developing data model. I am experienced in developing ER diagram. I am experienced in normalization. And I can develop your database in Oracle, MySQL, Postgresql, SQL server. Thank you.
Hi,
More than 4 years 'speaking' SQL Server and MySQL and 3 SQL certifications :)
I think I can help, and have some SQL fun..
Hope to collaborate!
Regards, Derley
Hi,
I need more information about this project.
Which language do you prefer to implement this CD shop management application? If you do not care, I plan to use java.
There should be several tables to store CD/track data, customers' data and business trace data.
When the shop buy/sell CD, above tables will be modified by the application to update data.
Do you need a GUI to show the data or just command line to operate?
BTW, do not find your requirements attachment. Any detail requirements please send pm to me.
Hi there , I'm delphi coder I used to do similar jobs just like the one you have mentioned I mean writing database driven application using the latest technologies like FireDac,ADO,Zeos and so forth with the latest RDBMS like ACCESS,MYSQL,SQLSERVER,FireBird now regarding to your project which is about managing a CD shop well the database could be created using either an openSource or a comercial RDBMS like the one mentioned previously and creating tables for an Album,Track,Singer,Category and so forth besides I will create a good-looking User Interface to access to this database and add and modify and delete for the ease of access besides we can make a user access system with privileges to allow a specific users to tamper with data and more ather features check out my portfolio for my recent application after all it is your verdict ^^
Best Regards
Hello Dear,
How complex it could be, more complex I done. An expert for SQL SERVER is here. Front end will be in VB.NET or else. I can do it for your pleasure.
Can give me a chance.
Thank you
I do have 10+ years of experience. Has been part of database design of few major projects. I do have experience in MYSQL and POSTGRESQL.
I would like to hear from you.
I am currently a Data Integration Specialist. Have been using Oracle database for 3years, other database like MySQL Postgre Ingres/Vector SQL Server and other columnar database. Data Migration and Data Warehouse were some of the projects that i handled and have been part of.
Hi I'm a DB and Warehousing Engineer. The requirement is directly base on a DB modle so i can provided a script with Required DDL for creating the Mysql DB with all the relationship and required condition
Hi
I am Dr. Asad
Have been teaching database design and analysis to undergrads for the past 10 years.
I can do this for you very easily
let me know
Asad
Hi,
I am working professional in the database space for more than 10 years.. I will be your best guy to get this job done. let me know if you want to discuss this further and accept my bid.
regards,
ganesh