Dear users, problem here is I have been given a project that is to be undertaken by a group, unfortunately group members have dropped out and tackling this alone, I am completely lost. The task is as follows, based on a case study (that I will not put up yet, but concerns a booking system for a university, contains about 10 entities).
THese are the following question I need help with;
a) A fully annotated E-R diagram 1 and 2 showing the entities, primary and foreign keys,
composite keys, relationships, optionality and cardinality.
b) A Relational schema of your database in 3NF, clearly indicating attributes, the data
type of each attribute, primary and foreign keys, candidate keys, and which attributes
are nullable, giving reasons. List any assumptions you need to make.
There is alot more to this coursework, but so far just getting the ERD1 & 2 correct has proven difficult. I need someone to attempt both so I can compare it against what I have so far.