BMGT 402 Lecture Notes - Lecture 14: Logical Data Model, Referential Integrity, Foreign Key

• School: University of Maryland
• Department: Business and Management
• Course: BMGT 402
• Professor: Woei- Jyh Lee

Document Summary

Bmgt402 lecture 14 - chapter 17: er schema to relational schema: overview database design methodology, build conceptual data model, build and validate logical data model b. i. Objective: create relations to represent entities, relationships, and attributes that have been identified b. iii. Merge logical data models into global model (optional) b. viii. Check for future growth: translate logical data model for target dbms, design file organizations and indexes, designer user views, design security mechanisms, consider the introduction of controlled redundancy, monitor and tune the operational system, keys a. i. Staff does not have branchno as a foreign key a. iii. Instead, it has staff has branch: er schema to relational schema strong entity type, create a relation for each strong entity type a. i. Flatten composite attributes into simple component attributes a. iii. Client (clientno, fname, lname, telno, email) is written as a. iv. 1. Name a. iv. 2. a. fname a. iv. 2. b. lname a. iv. 3. telno a. iv. 4. email: weak entity type b. i. Flatten composite attribute into simple component attributes b. iii.