instructions are below provided
This set of questions refers to your own class project. Please try to do it on your own. Giving you
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlinesOrder Paper Now
feedback here is the instructor’s way to get to know your own understanding of the material. Grading
here is independent of that for the class project.
(a) Please draw the complete ER/EER diagram using the ER/EER approach that we learned in the CLP class sessions and in the lecture-note PowerPoint file for your own project case, clearly indicating
the entities and relationships. For each entity, please include the entity name and all the candidate
key attributes (underlined) in the diagram. For each relationship, please include the relationship
name and the cardinality ratios between itself and each of its participating entities. (You do not have
to list all the non-key attributes of the entities here.)
Please paste the diagram to your homework document, so that the diagram is directly visible
without having to click on any link or icon. This is because your homework will be printed on
paper for grading. Any necessary further clicking may lead to the diagram not being graded.
Thank you for your co-operation.
(b) For each entity, if all the underlined key attributes form more than one possible set of candidate keys, please clearly indicate all the different possible candidate keys separately in text outside the ER/EER diagram. For example:
Candidate Key Set 1: Student_ID
Candidate Key Set 2: the combination of Student_Nameand Student_
If none of the entities have more than one set of candidate keys, then state so explicitly. (c) BONUS: Please use a documentation table to document the attributes of EACH entity: attribute name, data type, and cardinalities. Please also give one sample attribute value. For example:
(d) BONUS: For EACH relationship, if it has an attribute (other than the key values of its participating entities which are implicit), please state each attribute name, attribute data type, and attribute cardinalities. Please give one sample attribute value. Please use a documentation table. An example is given below.
Please answer each question properly with the relevant answer and at the proper level of detail, as stated in eachquestion. If a question asks for a particular thing and a student gives a whole bunch of things that contains that one answer (for the instructor to choose), this is equivalent to not answering the question at all.