Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Analysis Valuation Using Financial Statements

Authors: Paul M. Healy

5th edition

1111972303, 978-1111972301

More Books

Students also viewed these Accounting questions

Question

Write a business model for a hair salon

Answered: 1 week ago