Introduction
This is an individual assignment. You must submit it as an individual. Week2&4 homework together will be weighted 10% of your final subject grade. For ERD and other type of diagram-related questions, you can use ERAssistant, Diagram.net, Word or other tools to draw your diagram. You can also draw the ERD on a piece of paper and insert the photo to this homework.
Please write your student number and full name here:
Student Name:
Student Number:
Date:
Section 1 – Define each of the following key terms (5 marks):
1. Metadata
2. Database management system
3. Entity instance
4. Identifying relationship
5. Cardinality constraint
Section 2 – The following information relates to driver license. Identify the type of data (structured or unstructured). Differentiate between data and metadata (2 marks)
• Driver’s name, address, and birthdate
• The fact that the driver’s name is a 30-character field
• A photo image of the driver
• The resolution (in megapixels) of the camera that was used to photograph the driver
Section 3 – Describe a database that you are familiar with (3 marks)
• Briefly explain what type of system the database supports (e.g. order management, library loans, personal banking).
• How do you think using a database affects the quality of the service or product provided by that organization or business? Why?
• List the entities (4 to 6 are enough) and relationships that you think the database contains. If you are not sure of these, first identify the kind of data items that you think would need to be stored in the database and then form entities from these data items. For example, with bookshop database system, some data one could initially list are price, title, author, stock-level. These are characteristics that need to be stored about a particular thing i.e. a book (a.k.a. an entity!).
Section 4 -ERD (10 marks)
• Draw an ERD containing Student and Paper entity types connected by a one-to-many (1-M) relationship. Some of the students may do not have any paper. The Student entity type should have attributes for StdNo (primary key), StdFirstName, StdLastName, StdAdmitSemester, StdAdmitYear, and StdEnrollStatus (full or part-time). The Paper entity type should have attributes for PaperNo (primary key), PaperTitle, PaperSubmitDate, PaperAccepted (yes or no), and PaperType (first, second, proposal, or dissertation). Add a 1-M relationship from Student to Paper. (3 marks)
• Extend the ERD from problem 1 with an Evaluator entity type and a many-to-many (M-N) relationship between Paper and Evaluator. A paper may do not have any evaluator and not all the evaluators have got a paper to rate. The Evaluator entity type should have attributes for EvalNo (primary key), EvalFirstName, EvalLastName, EvalEmail, and EvalOffice. The M-N relationship should have attributes for EvalDate, EvalLitReview (1 to 5 rating), EvalProbId (1 to 5 rating), EvalTechWriting (1 to 5 rating), EvalModelDev (1 to 5 rating), EvalOverall (1 to 5 rating), and EvalComments. Please note that for this question you need to draw a many-to-many (M-N) relationship only ( you will need to change it to an associative entity type in the next step). (3 marks)
• Transform the M-N relationship from problem 2 into an associative entity type and identifying relationships. (4 marks)