Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Lab 2 Tasks For each of the following scenarios, identify potential entities, attributes, and identifiers. Not all entities may have identifiers Submission An MS-Word
Lab 2 Tasks For each of the following scenarios, identify potential entities, attributes, and identifiers. Not all entities may have identifiers Submission An MS-Word document named as follows: lastname_firstname_lab2.docx The document must include you name and student number. See the below sample as an example of how to populate the document. Late submissions will not be accepted. Sample of word document contents: Student Name: Bob Student Student Number: 0123456789 Scenario 1 Entity A -> identifier 1, attribute 1, attribute 2, attribute 3 Entity B-> attribute 1, attribute 2, attribute 3 Scoring Each scenario will be graded on a scale of 0 to 5 as follows: 5 -> all potential entities, attributes and identifiers have been identified. 3 -> a significant number of entities, attributes and identifiers have been identified. 1 -> almost nothing was identified 0 -> not submitted, completely incorrect, etc. Scenario 1 A local veterinary hospital is currently looking for a replacement for their patient tracking system. When asked to describe their data, they responded as follows. A client may have one or more pets. We often look clients up by phone number and we keep track of their name and address. A pet is owned by a single client. A pet is identified by their owner and their name. We keep track of their species, breed, sex, neutering status. A pet can be treated by several different doctors or technicians. Each doctor and technician have an employee number and a name. A pet may have multiple visits that need to be tracked by date and reason for visit. Scenario 2 A software development company has several departments such as engineering, quality assurance and tech support. The company has many employees. Each department has a manager and at least one employee. Employees must be assigned to at least one, but possibly more departments. Projects have name, unique tracking number and at least a single employee. An employee may or may not be assigned to one or more project depending on current circumstances. It is important to track the names of the departments, projects, managers and employees, as well as the manager and employee number and a unique project number.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started