Member Avatar for gungrave12

Hey Guys, I was wondering if I could get some feedback on this E-R diagram I am doing for a project. Not looking for a straight up answer, just pushes in the right direction if something is amiss. This is the problem as given to me, and I've attached what I came up with:

The Problem Domain
The problem domain can be characterized by the following:
• Each user (Survey Designer or Survey Taker) has a unique id (u_
addition, each Survey Taker has a date of birth and an age.
• A survey has a unique id (s_id), a survey password (s_pw) (so that
made available only to people who know the password), a title, an
status (indicating, for example, whether the survey is open to takers).
• Each survey is created by a single Survey Designer.
• Each question has a unique question id (q_id) and the question text.
• For each question on each survey, there is a set of choices, each
choice id (c_id) and the choice text.
• When a survey taker takes a survey, she will choose an answer from
for each question on that survey. (Of course, that information will be
database, so the survey designer can analyze the results later.)

er.jpeg 48.19 KB
  • 2 Contributors
  • 4 Replies
  • 276 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by whiteyoh
Member Avatar for whiteyoh

Hi,

Firstly i would suggest moving away from that style of ERD. its not very helpful at all and your resolves wont be clear.

take a look at this crows feet notation that is used in the SSADM methodology

Member Avatar for whiteyoh

The main thing that helps me to check something is for every relationship i write a sentence.

So say i have a 1 to many, say student to a module id write underneath

"A student can register on one or more modules"
"A module will be attended by more than one student"

then I would choose how to create the relationship

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.