Quiz2

pdf

School

Southwestern University *

*We aren’t endorsed by this school

Course

4347

Subject

Computer Science

Date

Apr 3, 2024

Type

pdf

Pages

6

Uploaded by DukeMusicSeal30

Report
CS-4347-006 Quiz 2 September 14, 2023 1 Last Name: First Name: Cohort: Grader: Grading Quiz #2 is different than most quizzes because design is subjective. Answers must not be blank, and the students are required to use specific structures in their design. The rest is how well does their dictionary match their diagram. Points Breakdown: EER Diagram • It has to look like an EER diagram. If it does not, -50 outright and continue. • All entites have a label. 5 points. • All necessary primary keys, if they are missing primary keys on strong entities, deduct 5 points • Appropriate attributes, if they have entities that have no attributes, deduct 5 points. • All cardinalities, If they have the .*,1, M,N or similar notation, fine, if not deduct 5 points. • All participations. There has to be lines between their entities and relationships. Double or single lines, use your best judgement.5 points. • at least one weak entity-Has to be one weak entity with an identifying relationship. 10 points • must include at least one class lattice with a super class and subclasses. 10 points. Assumptions Does not need to match my assumptions, but cannot be blank. 5 points each. Entity Dictionary: Does their dictionary match their diagram? For everything that does not match their diagram, take off two points. Do not take off more than 30 points. Relationship Dictionary Does their dictionary match their diagram? For everything that does not match their diagram, take off two points. Do not take off more than 10 points. Objective: Demonstrate your ability to draw an Enhanced Entity-Relationship Diagram and to create the Entity Dictionary and the Relationship Dictionary. You may work either individually or with members of your cohort. Your cohort may turn in a
CS-4347-006 Quiz 2 September 14, 2023 2 set of qui zzes stapled, but each quiz must have the correct student’s name at the top, and the topmost quiz will be graded. Pace yourself carefully! Mini-world Description: Surgeons perform operations following a schedule. Each surgeon has a hospital id number, a last name and a number of years they have been in practice. Each operation has a price, an identifiying cost-code, and a procedure name. Each operation must be scheduled. The schedule is a record of the operation. The schedule includes the date, the time, and the location of the operating theatre. (The operating theatre is not an entity in this mini-world) While this miniworld includes many different types of surgeons, three particular types of surgeons have additional attributes. Surgeons specialize, meaning they can only ever be trained as one type of surgeon. The first type is the Neurosurgeon, that uses the results of an MRI scan to plan their surgery. The second type is the Orthopaedic surgeon, that uses the results of an XRAY to plan their surgery. The third type of surgeon is the Cardiac surgeon, that uses the results of an EKG to plan their surgery. Question 1: Draw an Extended Entity Relationship Diagram (50 points) The diagram must use the symbols and methods from the lecture. If the Enhanced Entity Relationship diagram is not in the correct form, the quiz will be thrown away and given a grade of zero. Your diagram MUST include • All necessary primary keys • Appropriate attributes • All cardinalities • All participations • at least one weak entity • must include at least one class lattice.
CS-4347-006 Quiz 2 September 14, 2023 3 Recommended page for Entity Dictionary and Relationship Dictionary ENTITY DICTIONARY Entity: Cardiac Surgeon Description: A heart surgeon Attribute: EKG, VARCHAR(120) Primary Key: ID NUMBER, subclass of SURGEON Entity: Neurosurgeon Description: A brain surgeon Attribute: MRI, VARCHAR(120) Primary Key: IDNUMBER , subclass of SURGEON Entity: Operation Description: An operation on a patient performed by a surgeon Attribute: Cost-Code, INT Attribute: Price, Float Attribute: Procedure, VARCHAR(80) Primary Key: Cost-Code Entity: Orthopedic Surgeon Description: A Bone Surgeon Attribute: XRAY, VARCHAR (120) Primary Key: IDNUMBER from superclass SURGEON Entity: Schedule Description: A record of the time and place of the operation Attribute: Date1, Date Attribute: Room, INT Attribute: Time1, TIME Primary Key: Weak entity of Operation, 1-to-1 cardinality, uses Operation Cost-Code Entity: Surgeon Description: The individual performing the surgery, who has a number of years of experience. Attribute: ID Number, INT Attribute: LName, VARCHAR(80) Attribute: Years, INT Primary Key: ID Number RELATIONSHIP DICTIONARY Relationship: Has Description: An operation has a schedule for a single time. Entities: Operation, Schedule Participation: Operation, Partial to Schedule, Total Cardinality: Operation,1 to Schedule, 1 Relationship: Performs Description: A surgeon performs many operations Entities: Operation, Surgeon Participation: Operation, Total to Surgeon, Partial (You cannot have an operation without a surgeon) Cardinality: Operation, Many to Surgeon, 1
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
CS-4347-006 Quiz 2 September 14, 2023 4 Question 2: Assumptions about your diagram. Answer the following: • Why did you choose your weak entity? (5 points) The schedule of the operation is very specifically a record of the operation. The schedule is not a physical action or a physical object. All of these indicate Schedule should be a weak entity. • Why did you choose the class lattice specialization in your diagram? (5 points) The Surgeon is described as having specific types. Objects and items in a database that are “of a kind” is a clue that the surgeon is the class lattice, and the types of surgeons are the subclasses. Question 3: Entity and Class Dictionary (30 points) Due to the time limit, the entity and class dictionary does not have to be in alphabetical order. Each entity will have at most a one-sentence description of what the entity represents. Each subsequent line will be one attribute and their datatype.. The last line of each entity dictionary entry should indicate which attribute is the Primary Key. Template: Entity: <Entity Name> Description: <A short sentence> For each attribute: Attribute: <Attribute Name>, <Attribute Data Type> Primary Key: <Attribute Name> Question 4: Relationship Dictionary (10 points) Relationship Dictionary: Do to time constraints, the relationship dictionary does not need to be in alphabetical order. Each relationship will have at most a one-sentence description of what the relationship does. The following line will have a list of entities involed in the relationship. The next line will be the participating entities in the relationship. The last line will be the cardinality of the relationship. Template: Relationship: <Name> Description: <Description> Entities:<Entity 1><Entity 2> Participation: <Entity1>Participation> to <Entity2><Participation> Cardinality: <Entity1><Value> to <Entity2><Value>
CS-4347-006 Quiz 2 September 14, 2023 5 Recommended page for EER Diagram
CS-4347-006 Quiz 2 September 14, 2023 6
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

CNET 237 Ch 6 EXAM.docx
CNET 237 Chapter 11 Exam.docx
CNET 237 Ch 15 EXAM.docx
CNET 237 Chapter 9 Exam.docx
Assignment1_Article_summary.docx
PRIYA LR&CFS QUIZ-7.docx
Quiz5.pdf
PS#7.pdf
PS#8.pdf
PS#9.pdf
PRIYA LR&CFS ASSIGNMENT-7.docx
PRIYA LR&CFS QUIZ-2.docx
Recommended textbooks for you
Text book image
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Text book image
Systems Architecture
Computer Science
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Cengage Learning
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Text book image
Systems Architecture
Computer Science
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Cengage Learning
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
SEE MORE TEXTBOOKS