Revise ERDs
Hey team, we (technical group) has revised the proposed ERDs as posted below. (Thanks to MI and ED!)
Feel free to suggest thought, as you see fit, the idea is to be able to deliver ontime based on the spec.
-Leong.
Revised Conceptual ERD:
This conceptual ERD provides the conceptual representation of the entities and associations for the BU-PMA website database. It provides the overall high-level view of the designed database, as describe below:
- Each user has one address.
- Each user has one access credential for the webpage login.
- Each address is associated to one user.
- Each access credential is associated to the only one user.
Revised Logical ERD:
The Logical ERD details the logical representation of the entities, their associations, and the data elements for the BU-PMA website database. The designed database is in 2nd normal form to better align with the business spec.
Leong,
The requirements of the project state the following:
“A dynamic database linked to the current site that will receive the following information from current and former students: Name, Current or Former student, former BU Email id or student number (for proof), email address, interested_in_contributing_how”
I don’t see fields for Current/Former, Student Number, and How Contributing in your model. Please add them. Thanks.
Comment by MI — February 2, 2008 @ 12:31 pm
MI,
I have updated the ERD to better reflect the spec, please comment.
Thanks,
Leong.
Comment by Leong — February 2, 2008 @ 1:20 pm
It’s looking good! Go ahead and start creating the tables in the server.
Comment by MI — February 2, 2008 @ 1:30 pm
MI,
I have created the db tables.
I made some assumptions on selecting the data type for each field (base on my research). For example, I have defined nvarchar(50) as the data type for User_IntdInContributing attribute instead of ntext, the reason is because some function (replace, substring, etc) that work on string will not work on ntext data type. We can verify this at the Application Tier.
-Leong.
Comment by Leong — February 3, 2008 @ 1:05 am