Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A company that performs maintenance jobs for apartments in an apartment complex i welling to implement a database system that manages and monitors work order

image text in transcribed
A company that performs maintenance jobs for apartments in an apartment complex i welling to implement a database system that manages and monitors work order task and the materials used in each work order. The following is a description of the system as it was provided to you by the company representatives. The system is intended to manage and monitor maintena nce work orders. Work orders are usually submitted by customers who report various maintenances tasks that need to be done in a specific apartment. Customer records contain a unique identifier for each customer, the name of the customer, and the billing address (street, city, state, and zip code). The database should also contain a detailed list of all the work orders submitted by all customers. A work order is submitted by one customer and it contains a unique order number, date of creation, the requested date of completion, the actual date of completion , the customer who submitted the work order, the location where work is requested (apartment number), and a list of all the tasks needed to be done. Each task has a unique identifier, task description, an hourly rate, estimated hours ed to complete the task, the status of the task (not started, in progress, or used to completed), the actual hours, the completion date, the list of all the materials plete the task, and the worker(s) who were assigned to the task. Each task can ompleted by more than one worker e database should also include data about the workers who perform the tasks listed in work orders. Each worker has a unique identifier, name, hiring date, and a job title To be able to calculate the cost of the work order, the company information about the materials used in work orders. The data about include, a unique material identifier, description, and cost needs to maintain materials should eria . The mat ar i than one work ord Using the Crow's Foot notation, draw the Entity Relationship Diagram (ERD) for this database

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

Step: 3

blur-text-image

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

Demystifying Databases A Hands On Guide For Database Management

Authors: Shiva Sukula

1st Edition

8170005345, 978-8170005346

More Books

Students also viewed these Databases questions

Question

What is a contingency plan?

Answered: 1 week ago