Need help for creating a SQL DataBase

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

Database Design and Application Architecture

Need help for creating a SQL DataBase

Author

Topic

1452snake13
Starting Member

2 Posts

Posted - 2007-11-26 : 13:36:48

Hello everybody, my name is Andy,

I need help for creating a database, it's an exercise for my school, we just began to learn SQL, about entities, relationships (one to one, one to many...), creating tables, but the thing is i don't know where to start, i think i need to practise but it's hard to transform a text into a database, i think i need some help from you guys and i hope you will help me.

I give you the exercise, and what i found :

Project wants users to be able to initiate debates, post articles and get to the achieved items. A user should be able to write as many articles as desired after having register with login and passport

However articles should contain these references for more http links, URL, summary of the content; 1 or more books, article, doc, case studies …

1)Identify the data objects and relationship and draft the initial ER Diagram with entities and relationships. Normalize model as far as you can

2)write the SQL query / link (url) and corresponding summary

About the 1)
Entities : users --> login and password associated (one to one relationships one user = one login/password)
Articles --> associated with the users accounts (one to many)

I am not sure for creating the different tables, im a bit lost... :s

About the 2) totally lost, i need the 1) to make the SQL Query (i know a bit about queries)

I hope you will help me, i am a beginner in SQL (only one course taken) and it is our first exercise, thanks for your help all!!!