Find Jobs
Hire Freelancers

SQL DATABASE DESIGN

$10-30 USD

Fullført
Lagt ut over 5 år siden

$10-30 USD

Betalt ved levering
1. Database Design: A list of all tables in the database using DBDL in at least 3NF. 2. Database Design: Create an E-R Diagram showing each table, the attributes of the table, the primary key and any foreign keys. Please show the relationships between the tables and the type of relationship (1-to-1, 1-to-many, etc). HERE ARE THE REQUIREMENTS- Someone suggests that you meet for a dessert (or two) at a local restaurant. Its is important to pick the right place. Each person has favorite desserts. We need to select a place that serves at least one dessert each person likes. To solve the problem, you decide to design a database to keep track of all the students in the class including their first and last names(required). Each student has a five character id that is unique. You will also record the name of three desserts a student likes. A student may like many different desserts, and many students may like the same dessert. Also, we need to keep track of all the names of all restaurants in the area(required), their phone number and all the different desserts they serve. We need to note the location of each restaurant so that we can easily find the location. A restaurant may serve many desserts, and many restaurants may serve the same dessert. For each dessert, you need to record the name of the desert (required), the price of the dessert which must be greater than zero and the number of calories in the dessert which is between 300 and 1000.
Prosjekt-ID: 18332330

Om prosjektet

2 forslag
Eksternt prosjekt
Aktiv 5 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
Tildelt til:
Brukeravatar
Hey i am a professional Developer and have a experience of that field kinldy inbox for more details.....................
$25 USD om 1 dag
4,9 (9 omtaler)
2,8
2,8
2 freelancers are bidding on average $28 USD for this job
Brukeravatar
Hello, I can complete this task within 1 day. I'm a SQL Server professional with 7+ years of experience and also a certified specialist. Regards, Iaroslav
$30 USD om 1 dag
5,0 (1 omtale)
2,0
2,0

Om klienten

UNITED STATESs flagg
Naugatuck, United States
0,0
0
Betalingsmetode bekreftet
Medlem siden des. 10, 2018

Klientbekreftelse

Andre jobber fra denne klienten

In need of a java programmer!
$10-30 USD
Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.