Entity Relationship Question

G

Guest

I'm currently trying to complete some repeat coursework for college. I was
wondering if anyone could cast their eye over the Entity Relationship Diagram
below and tell me if its right. The brief is as follows:

UU wish to upgrade a number of their admin systems dealing with student
marks. You are to assume you have been given the responsibilty for this task
and will be responsible for maintainng a database containing all relevant
details of the modules and student marks.

The system will be initially piloted for year two of Computer Science. For
each module, in the pilot system, it can be assumed that only one member of
lecturing staff will be associated with each module. However, the scenario of
many students undertaking up to six modules in the year should be facilitated
for. In addition, module marks for each student are to be stored.

ERD below:

http://ijsr32.infj.ulst.ac.uk/~12047303/untitled.bmp

Any help greatly appreciated!
 
A

Arvin Meyer [MVP]

Looks good to me, but you will need to define the relationship 1 to many
between Staff (1) and Modules (many). In your code, you can easily make sure
that no more than 6 modules exist for any student in that year.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top