Re: ERD attributes or?
From: Barry <barryw_at_databaseanswers.com>
Date: 18 Dec 2003 14:07:35 -0800
Message-ID: <55816d8a.0312181407.150518d3_at_posting.google.com>
Date: 18 Dec 2003 14:07:35 -0800
Message-ID: <55816d8a.0312181407.150518d3_at_posting.google.com>
shannon <shannon_at_nolunchmeat.com> wrote in message news:<brp8q5$pq3$01$1_at_news.t-online.com>...
> hi all,
>
> I need to construct an ER diagram involving a student. The student has
> the usual attributes including student number, name, telephone etc.
I suggest a different approach based on studying relevant Data Models
and then creating one that meets your requirements.
This the approach that I would suggest which will help you in constructing an ER diagram that culd be used to design a Database for an operational system :-
- Start by looking at the Student-related Models on this page of the Database Answers web site :- http://www.databaseanswers.com/data_models/index.htm
- Identify the Data Model(s) that most closely match your requirements.
- Choose the Entities that you need (a valuable learning experience)
- Assemble the corresponding Business Rules
- Modify the Rules as appropriate.
- Assemble some Test Data - just 10 or 20 records.
- Define a typical User Scenario based on the test data.
- Put 4 pieces of paper on a desk or table -
- Data MOdels ii) Business Rules iii) User Scenarios iv) Test Data
- Reflect on them while driving, in the shower, on the bus/train, out walking and so on.
- Prepare a presentation to show the requirements,(Rules), and the logic of your solution.
- Let me know how it goes !
Good luck.
Barry Williams Received on Thu Dec 18 2003 - 23:07:35 CET