Technical Data Management And Applications

Technical Data Management And Applications

Technical Data Management and Applications

Assignment 2

1. Create an ER model for each of the following descriptions:

(a) A large organization has several parking lots, which are used by staff.

(b) Each parking lot has a unique name, location, capacity, and number of floors (where appropriate).

(c) Each parking lot has parking spaces, which are uniquely identified using a space number.

(d) Members of staff can request the use of a parking space. Each member of staff has a unique number, name, telephone extension number, and vehicle license number.

(e) Represent all the ER models described in parts (a), (b), (c), and (d) as a single ER model. Provide any assumptions necessary to support your model.

2. Customers submit orders for products the identifier for an order is Order-ID, and another attribute is Order_Date. A customer may submit any number of orders, but need not submit any orders. Each order is submitted by exactly one customer. The identifier for a customer is Customer_ID. Other attributes include Customer_Name and Customer_Address. A given customer order must request at least one product. Any product sold by Pine Valley Furniture may not be requested on any order, or may be requested on one or more orders. An attribute associated with each order and product is Quantity, which is the number of units requested. Pine Valley Furniture has established sales territories for its customers. Each customer does business in one or more of these sales territories. The identifier for a sales territory is Territory_ID. A sales territory may have any number of customers, or may not have any customers doing business. Pine Valley Furniture Company has several salespersons. The identifier for a salesperson is Salesperson_ID. Other attributes include Salesperson_Name, Salesperson_Telephone, and Salesperson_Fax. A salesperson serves exactly one sales territory. Each sales territory is served by one or more salespersons. Each product is assembled from one or more raw materials. The identifier for the raw material entity is Material_ID. Other attributes include Unit_of_Measure and Unit_Price. Each raw material may be assembled into one or more products. Raw materials are supplied by vendors. The identifier for a vendor is Vendor_ID. Other attributes include Vendor_Name and Vendor_Address. Each raw material can be supplied by one or more vendors. A vendor may supply any numver of raw materials, or may not supply any raw materials to Pine Valley Furniture. An attribute of the relationship between vendor and raw material is Unit_Price. The company has over 100 employees. The identifier for employee is Employee_ID. Other attributes are Employee_Name, EmployeeAddress, and Skill. An employee may have more than one skill. A skill can be mastered by many employees. Each employee works in one or more work centers. A work center must have at least one employee working in that center, but may have any number of employees. Each employee has exactly one supervisor. An employee who is a supervisor may supervise any number of employees, but not all employees are supervisors.

Above is the requirements data for a Sales Order database. The ERD for the requirements is below. Please convert this ERD to the Chen’s model of ERD. Do not include the (min, max) as shown on the ERD. Only use the cardinality ratio. I.e. 1:1 or 1: N or N: M

Skill

PKskill_ID

skill_Name

description

Salesperson

PKsales_ID

sales_Name

sales_Telephopne

sales_Fax

SalesTerritory

PKterritory_ID

territory_Name

Employee

PKemployee_ID

employee_Name

address

ProduceLine

PKline_ID

line_Name

Customer

PKcustomer_ID

customer_name

customer_address

WorkCenter

PKcenter_ID

location

Product

PKproduct_ID

description

unitPrice

finishTime

Order

PKorder_ID

date

RawMaterial

PKmaterialID

unitOfMeasure

Vendor

PKvendorID

vendorName

vendorAddress

attribute

quantity

attribute

unitPrice

has

submits

requests

produces

uses

supplies

works

has

belongs

groups

supervises

(1..*)

(0..*)(1..1)

(0..*)

(1..*)

(1..1)

(1..*)

(0..*)

(1..1)

(0..*)

(1..1)

(1..*)

(1..*)

(1..*)

(1..*)

(0..*)

Essay writing help – Technical Data Management And Applications Online Essay Writing Agency – Pro-Dissertation.

Write my Essay. Premium essay writing services is the ideal place for homework help or essay writing service. if you are looking for affordable, high quality & non-plagiarized papers, click on the button below to place your order. Provide us with the instructions and one of our writers will deliver a unique, no plagiarism, and professional paper.

Get help with your toughest assignments and get them solved by a Reliable Custom Papers Writing Company. Save time, money and get quality papers. Buying an excellent plagiarism-free paper is a piece of cake!

All our papers are written from scratch. We can cover any assignment/essay in your field of study.