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
 General SQL Server Forums
 New to SQL Server Programming
 HOW TO CREATE TABLE IN SQL

Author  Topic 

MUKE YA MUHA
Starting Member

4 Posts

Posted - 2012-08-10 : 09:44:56
You have been asked to create a database that will store data used by the Sales Department.
The Sales Manager has asked you to provide storage for SalesPersons, Customers, Orders , OrderDetails and Products. She has left it to determine what properties should be stored each table.

What steps will you take to perform this request, and what code will you use when creating the database and the tables?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-08-10 : 09:57:01
can we see what you tried yet? unless you try it we wont help with homework questions!

hint: use CREATE DATABASE and CREATE TABLE statements

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2012-08-10 : 10:00:06
I'll echo Rick's reply here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=177466

We don't answer exam, homework, or certification questions on SQLTeam. We're happy to help you if you post what you've tried, but we won't design the whole thing for you from scratch.
Go to Top of Page

xhostx
Constraint Violating Yak Guru

277 Posts

Posted - 2012-08-10 : 10:05:46
try and look at this quick reference to start with

http://www.databasejournal.com/features/mssql/article.php/3759371/Create-Your-First-SQL-Server-Database-in-3-Quick-Steps.htm

--------------------------
Joins are what RDBMS's do for a living
Go to Top of Page
   

- Advertisement -