Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 SQL Table please help me out :/

Author  Topic 

noobofbig
Starting Member

1 Post

Posted - 2013-05-21 : 17:42:58
A MC-company wants to develope a computer system that can answer these questions:

? Name, Adress and Phonenumber for the customers
? Price, Brand, Model and category (sortof: sports, touring or custom) for a MC
? All the MC's a customer has bought.
? When the customer bought the MC (date)
? Customernumber and name for all customers who have bought a MC
? All the MC's in stock

These rules need to be applied:

? A customer can buy many MC's
? An MC can only be bought by 1 customer
? A MC is identified by a registernumber
? A customer is identified by a customernumber

HELP :/

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2013-05-21 : 20:10:29
Most people here will help with homework, some will even do it for you, but you really need to give it some effort. Show us what you have come up with so far, and then we can help you get the rest of the way.

Jim

Everyday I learn something that somebody else already knew
Go to Top of Page
   

- Advertisement -