Data Model - Assignement 1

.docx

School

University of Texas, Dallas *

*We aren’t endorsed by this school

Course

6320

Subject

Business

Date

Apr 3, 2024

Type

docx

Pages

2

Uploaded by MajorFire1958

Report
BUAN 6320 – Fall 2022 Major Assignment 1 – Data Modeling SCOPE: Designing Relational Data Model for Parking Lot Management Create an ER model for each of the following descriptions: A large organization has several parking lots, which are used by staff. Each parking lot has a unique name, location, capacity, and several floors Each parking lot has parking spaces uniquely identified using a space number. Staff members can request the sole use of a single parking space. Each staff member has a unique number, name, telephone extension number, and vehicle license number Most parking spaces are under cover, and each can be allocated for use by a staff member for a monthly rate. Parking spaces that are not covered are free for staff use, and each can be allocated for use by a staff member. Up to twenty covered parking spaces are available for use by visitors to the company. However, only staff members can book a space for the day of the visit. There is no charge for this type of booking, but the staff member must provide the visitor’s vehicle license number. Parking management able to display available spaces on each floor Any cars that violate the rules should be charged a nominal fee Represent all the ER models described above as a single ER model. Provide any assumptions necessary to support your model. Possible Entities Involved STAFF LOT RESERVATION/BOOKING LOT_INVENTORY DEDUCTION_METHODS PAYMENTS
Expected Results in Assignment. A minimum of six pages of the document contain the following. Section 1: Brief description of the problem. (What is being asked and its purpose) Section 2: Business Rules, Come up with a minimum of 20 business rules/Assumptions. Section 3: Conceptual Design as per Chen’s Model Section 4: Logical Model - ERD diagram with a minimum of 8 entities and their relationship Section 5: Physical model script developed for MySQL (Use MySQL workbench) Each Entity should satisfy at least 2NF Each table should have a primary key Relationships should have a foreign key
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