need help in ERD (1 Viewer)

[qurawe]

PLS need help in ERD [FONT=&quot]scenario[/FONT]

[FONT=&quot]We have been asked to analyze the data requirements and develop a conference management system to keep information about all the conferences and papers presented in the conferences. [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Conferences are conducted in different parts of the world. Each conference is identified by its name and year of the conference. The conference has a starting and ending dates, fields, and conference location (country, venue where that conference is held, and country international telephone code). The conference may also organize some social activities. For each activity, the system stores the name of the place to be visited, date, duration and the price of visiting that specific place. [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]A conference would receive lots of paper to be submitted to the conference, but only selected number of these papers will be accepted. Each paper is identified by its main author and title. The paper also has number of pages and secondary authors (if any). In addition, each paper is given a type (e.g. S: Survey, B: Brief, F: Full, P: Poster). A paper can be submitted in only one conference and many papers may be submitted to the same conference. Once a paper is submitted in a conference, the system sends a message to the author acknowledging the paper submission. For each submitted paper, the system stores whether this paper is accepted or not. [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]If a paper is accepted, at least one author should attend the conference to present the paper. We want to keep information about the author who presented the paper in the conference. Each author is identified by a unique AID, has a name, address, affiliation and contact telephone number of this affiliation. An author can write one or more research papers and a paper have one main author and one or more secondary authors. Furthermore, an author may attend many conferences, for each attendance we need to store the attendance type (presenting a paper, visitor, student,..) and if the attendee has any disability needs. [/FONT]
[FONT=&quot]The system should also store the number of papers submitted and accepted for each conference, in addition to number of attendees. Authors attending the conference may register for one more of the activities offered by the conference. For each registration, the system store number of persons accompanying the author. [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Task to be done: [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]You are required to do the following tasks: [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]1.[/FONT][FONT=&quot] [/FONT][FONT=&quot]Use the above information to build an E-R diagram. Note that there is some missing information in the scenario. To complete the task, you can make reasonable assumptions about the missing information. All the assumption made by you must clearly be mentioned in the report before making the ER diagram. [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]2.[/FONT][FONT=&quot] [/FONT][FONT=&quot]Map the ERD to relations. Identify the primary key for each entity. [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]3.[/FONT][FONT=&quot] [/FONT][FONT=&quot]For each of the relations created, indicate its normal form. If the relation is not in the 3NF, decompose it into 3NF relations. [/FONT]

 

[stopher]

This looks like school work.

Where do you need help exactly? What do you have so far?

Chris

 

[qurawe]

This looks like school work.

Where do you need help exactly? What do you have so far?

Chris

I do this first step drawing but I think it’s wrong pls check it, and if you can help me in the anther step needed.

I do this first step drawing but I think it’s wrong pls check it, and if you can help me in the anther step needed.

 

[qurawe]

111111111111

 

[qurawe]

2222222222222

 

[qurawe]

33333333333

 

[qurawe]

 

[stopher]

I'm afraid I'm not very familiar with this ERD notation so I'll stick to some points I can see.

Also, please note that the teaching of ERDs does vary a bit so you will have to take what I (and others say) in context with what you've been taught.

You seem to have two paper entities ("Paper" and "Research Paper"). But aren't these the same?

For the entity Research Paper, you have attributes Main Author and Secondary Author. I would expect these two elements to be define by links to the Author entity. At the moment you have a relationship "can write". But you could change this to something like "is main author". Maybe you can see where I'm going with this point. The same applies to Paper.

Your diagram shows Authors "registered" to Activities. But where does it say this in the brief?

I can't see anything in your ERD that would tell me which author is presenting an accepted paper.

What's the difference between Receive and Submitted? I appreciate the wording in the brief is not clear but in my mind it's the same thing. I may be wrong.

How do you represent one to many in your diagram (as mentioned I don't know this notation). There are several one-many references in the brief which I would expect to be visible in your ERD.

good lcuk

Chris

 

[boblarson]

111111111111

Instead of posting this crap, all you had to do is ZIP your image and then upload it. It wouldn't be shown inline but you could have done all of that with a single post.

 

[qurawe]

I'm afraid I'm not very familiar with this ERD notation so I'll stick to some points I can see.

Also, please note that the teaching of ERDs does vary a bit so you will have to take what I (and others say) in context with what you've been taught.

You seem to have two paper entities ("Paper" and "Research Paper"). But aren't these the same?

For the entity Research Paper, you have attributes Main Author and Secondary Author. I would expect these two elements to be define by links to the Author entity. At the moment you have a relationship "can write". But you could change this to something like "is main author". Maybe you can see where I'm going with this point. The same applies to Paper.

Your diagram shows Authors "registered" to Activities. But where does it say this in the brief?

I can't see anything in your ERD that would tell me which author is presenting an accepted paper.

What's the difference between Receive and Submitted? I appreciate the wording in the brief is not clear but in my mind it's the same thing. I may be wrong.

How do you represent one to many in your diagram (as mentioned I don't know this notation). There are several one-many references in the brief which I would expect to be visible in your ERD.

good lcuk

Chris

thanks very much stopher

your point is very good i accept all your point and i will take to my drawing.

if you have anther point pls posted her to see it and other friend can say something a bout it.

 

[qurawe]

Instead of posting this crap, all you had to do is ZIP your image and then upload it. It wouldn't be shown inline but you could have done all of that with a single post.

thanks boblarson about this information because i am first time member so i need (10) post , so i can post i picture.

thanks again

 

[boblarson]

thanks boblarson about this information because i am first time member so i need (10) post , so i can post i picture.

thanks again

I have posted a sticky in each category explaining that users with less than 10 posts can upload a picture or database file if they just zip it first. New users still can't use the inline picture but can upload the picture file here if zipped first.