Week 5 Asynch

.pptx

School

The University of Tennessee, Knoxville *

*We aren’t endorsed by this school

Course

MISC

Subject

Information Systems

Date

Dec 6, 2023

Type

pptx

Pages

16

Uploaded by DoctorHeronPerson891

Report
Database design Schema-on-Write Creating our BUAD342 Company Database
Table structures actually used in reality are far more complex than any examples we will discuss Our design process will be overly simplified
A Real-World Database
The steps: 1. Map Reality (Understanding of Business Process Needs) into Conceptual Model (e.g., E-R diagram or Object Oriented graphic) 2. Map Conceptual Model into Logical Model 3. Create Physical Database using DBMS software Schema-on-Write Database Analysis and Design Process
Just like Kroger, the BA342 Company is a retailer too! About the company: (note: we are only discussing the OTC process) • The BA342 Company offers products for sale to customers. • The products come from BA342 Company’s suppliers. • The customers send BA342 Company orders that are executed by employees. • The orders become sales when they are shipped to the customers via shippers, hired by BA342 Company. The sample database you will use to practice skills does not include all OTC and P2P data – just a limited subset. The BA342 Company
Step 1: Map Reality (Understanding of Business Process Needs) into Conceptual Model (e.g., E-R diagram or Object Oriented graphic) Schema-on-Write Database Analysis and Design Process
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