create table for below sql query
$10-30 USD
Paguhet në dorëzim
Create a database of music CD's. Include tables for artist, genre, place of purchase. Include purchase date and price paid
Draw the ER Diagram
include surrogate keys in each table (primiary keys generated by the dbms)
Include foreign keys where appropriate
Insert at least 10 cds, 10 artists and 4 genres
after insertion, show an example of an update query that provides a new price paid for at least one CD.
Show the highest priced cd
Show CD's for a particular genre (show the name of the CD and the genre)
Show CD's for artists that have an 'e' in either their first or last names. (show the cd, artist, and genre)
Add 10% to the price paid for one genr
Show CDs purchased between two dates
Show CDs that are in 3 of the 4 genres.
Show how many CDs are in each genre
ID Projekti: #16206906
Rreth projektit
35 profesionistë freelancer dërguan një ofertë mesatare prej $28 për këtë punë
Hi there. I went through the requirements and I would like to do this project if given the opportunity. Let me know if you are interested so I can have further details.
Hey A SQL expert is here I have good advanced expertise in database development and writing the SQL Queries Feel Free to message me We can discuss about the details in chat Regards
I am having more than 8 years of experience in IT industry.I have worked on .net(c#.net,vb.net,asp,asp.net,mvc) with sql server 2005/2008/2012/2014/2016 and oracle(pl/sql). I can provide you better solution by utili Më shumë
Hello, i read your requirements of creating ER diagram, tables, data insert for your music project. I have done similar database design projects successfully on freelance. Please take a look at my profile for past Më shumë
Hi sir, I will create the tables, the ER diagrams and the queries for all the points given in your description within 2-3 hours starting right now, thanks
Hello, i have read your job description and fully understand your requirements. It looks like I’ll be the perfect candidate for this job because I have hands on experience in this field. Could you provide us more Më shumë
Hi there! I am an Australian Business Analyst with 15 years professional experience designing and building projects with SQL. I am also degree qualified in Information Systems, and tutored database subjects while at un Më shumë
hola comos estas ??, espero estes bien contratame para hacer este trabajo ten go mucha experiencia en sql y postgres mi preferencia te lo garantizo.
Hi I have experiance with sql server and database design so I can create this for you. I will create in that way that between purchasePlace and MusicCd tables will exist many to many relationship extended with purchase Më shumë
We are highly experienced Post Graduate Engineers, Doctors, IT, ITES, Software, Infrastructure Professionals, Web Designers and IT Architects. We can redo, improve, and publish any engineering, scientific MATLAB, SI Më shumë
Hi, there. How are you? I can do it, right now. I have a lot of experience about this. Talk to me if you want to. Bye :D
I've 2 years experience in SQL queries , I can do your job for only 10$ to prove my skills with the minimum cost to be paid
I noticed from studying the requirement listing that you need a person with strong SQL skills. I have a great deal of experience in SQL. I have created a databases for lot of times with high standard. I am also adept a Më shumë
I am new to freelancer.com but I work as a senior DBA in a company. I won't charge money until you are satisfied
