Need help with ER Diagram and Stuffs.

MarineX · #1 (**permalink**) 07-01-09, 08:51

You will design and create of a database application for any type of organization. You will define the main business activities of the organization. You must also provide a brief written description of the organization’s operational procedures and the list of derived “Business Rules”.

Assignment 1 (a) – ER Modeling

1. Identifying Entities and Attributes
2. Specifying Relationship Types
3. Identify and including constraints. (if applicable)
4. Identifying and including all key attributes, e.g primary, foreign
5. Draw an appropriately labeled E-R model diagram.

http://img195.imageshack.us/img195/695/picture1epi.png

can anyone help me out with this?

I need at least 5 entity.. but i have no idea how to squeeze the other one.

pootle flump · #2 (**permalink**) 07-01-09, 09:01

Marine - the very worst type of homework request is what you have just done: a copy and paste of the assignment and then asking for us to do your homework for you. In short, cheating.

You'll get fook all.

MarineX · #3 (**permalink**) 07-01-09, 09:05

Quote:

Originally Posted by pootle flump

Marine - the very worst type of homework request is what you have just done: a copy and paste of the assignment and then asking for us to do your homework for you. In short, cheating.

You'll get fook all.

i see... e very form of respect is to.. ignore it instead of leaving such comments, thanks!

pootle flump · #4 (**permalink**) 07-01-09, 09:07

I'm a mod. May I refer you to the rules section:
dBforums - Forum Guidelines

Cheating does not get ignored, nor cheaters respected.

pootle flump · #5 (**permalink**) 07-01-09, 09:09

Thread locked. I haven't deleted it so your teacher can find it if (s)he decides to google his\ her question text.

MarineX · #6 (**permalink**) 07-01-09, 09:10

Quote:

Originally Posted by pootle flump

I'm a mod. May I refer you to the rules section:
dBforums - Forum Guidelines

Cheating does not get ignored, nor cheaters respected.

i don't wish to argue anymore. Does anyone willing to help me out?

blindman · #7 (**permalink**) 07-01-09, 11:21

Quote:

Originally Posted by MarineX

You will design and create of a database application for any type of organization.

This assignment is so easy, I'm going to help you out despite Pootle's rudeness.

Here you go:

Code:

CREATE TABLE Everything
	(RecordID int NOT NULL PRIMARY KEY CLUSTERED,
	AllData xml NULL)
GO
ALTER TABLE dbo.Everything ADD CONSTRAINT
	DF_Everything_RecordID DEFAULT 1 FOR RecordID
GO

Assignment done. Ta-da!

Internet Services

Web Development

Digital Marketing

Consumer Tech