Data Modeling Part 1 - Creating an ERD Data Modeling, Par t...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Creating an ERD Data Modeling, Par t 1 When Arrow appears, left click anywhere or press Page Down Data Modeling All I T Systems consist of Data and Pr ocesses . I n this class, we are focusing on the DATA. I n this section we will began the process of modeling our data—creating a model or picture of the data elements and how they are related. Entity Relationship Diagram (ERD) Communication Tool that allows us to create a pictur e (model) of our data and how the various data elements relate to each other. This model is commonly used to model relational/object- relational databases. I mportant to understand the nature of the business: Type of database-- Tr ansactional, Decision Suppor t, H ybr id Business objectives --core business Predicted needs -- scalable, handle growth and changing Transactional Database I ssues: Concurren cy Throughpu t Scalability Designed to support the processing of business transactions such as the sale of a product Primary function is to support addition of new data, modification or deletion of existing data, and retrieval of data for business processing Relational or object-relational model Diagrams in I T Common practice to use diagrams to represent complex concepts: Physical Layout Network Diagrams Processing Logic Flowcharts or Pseudocode Flow of data between processes Data Flow diagram (DFD) Structure of Data Entity Relationship Diagram (ERD) Remember: The design must support the business objectives. Entity Relationship Diagram (ERD) Note that data is NOT moving… (no arrows!) No indication of HOW data got where it is. The “how” is a process. STUDENT ENROLLMENT COURSE SECT ION LOCAT ION CONTA INS / IS LOCATED AT TEACHES INSTRUCTOR D IV IDES /IS D IV IDED COURSE IS PRE-REQ SectionNum CourseNum Loca tion ID InstructorID RoomNum Day MaxEnro lmen t CurEnro lmen t S tuden tID LastName F irstName Ma jor C lass ifica tion G rad /UG rad PhoneNum S tuden tID Course ID Section ID Term G rade Course ID CourseName C red itHours Descrip tion , e tc.. Course ID , P reReqCourse ID . InstructorID Loca tion ID Example from Access... Components of an ERD Business Rules I nformation from the user’s business environment that governs how his data is used—for example, policies, pr ocedur es , constr aints, r egulations, for mulas and calculations ....
View Full Document

This note was uploaded on 09/21/2011 for the course CGS 2545C CGS 2545c taught by Professor L during the Summer '10 term at University of Central Florida.

Page1 / 20

Data Modeling Part 1 - Creating an ERD Data Modeling, Par t...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online