BUS 362 Lecture Notes - Lecture 3: First Normal Form, Second Normal Form, Requirements Elicitation

• School: Simon Fraser University
• Department: Business Administration
• Course: BUS 362
• Professor: Drew Parker

Document Summary

A formal way of representing the data that is used and created by a business system. Shows the people, places, and things about which information is captured and the relationships among them. Crucial information for the design phase data is often more complex than processes. Logical data model shows the organization of data without indicating how it is stored, created, or manipulated. Physical data model shows how the data will actually be stored in databases or files: investigate ways to store data efficiently and make it efficient to retrieve. Other data modeling is done throughout sdlc. Objective of data modelling: to minimize redundancy of a data base, to completely represent the required data in an information system. Entity relationship diagram (erd) is a picture which shows the information that is created, stored, and used by a business system. Crows foot: an lca can make many chemical requests and. Double bars: a chemical request is made by exactly one lca.