DOC PREVIEW
SJSU CMPE 226 - Data Modeling

This preview shows page 1-2-3-26-27-28 out of 28 pages.

Save
View full document
View full document
Premium Document
Do you want full access? Go Premium and unlock all 28 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 28 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 28 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 28 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 28 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 28 pages.
Access to all documents
Download any document
Ad free experience
Premium Document
Do you want full access? Go Premium and unlock all 28 pages.
Access to all documents
Download any document
Ad free experience

Unformatted text preview:

Database DesignPowerPoint PresentationSlide 3What Is Entity-Relationship Diagrams?Slide 5Slide 6Entity-Relationship DiagramsBusiness Rules (1)Business Rules (2)Business Rules (3)Business Rules (4)Business Rules (5)Business Rules (6)Business Rules (7)Business Rules (8)E-R Diagrams (1)Entity Relationship DiagramsDeveloping ERDsSlide 19How do we start an ERD? (1)How do we start an ERD? (2)How do we start an ERD? (3)ERDsCrucial Use of E-R Analysis (1)Crucial Use of E-R Analysis (2)Crucial Use of E-R Analysis (3)Discussion QuestionsTasks for Next Lecture2003SJSU -- CmpE L2-S1 ER DiagramsDatabase Design Dr. M.E. Fayad, ProfessorComputer Engineering Department, Room #283I College of EngineeringSan José State UniversityOne Washington SquareSan José, CA 95192-0180 http://www.engr.sjsu.edu/~fayad2003SJSU – CmpE --- M.E. Fayad L2-S2 ER Diagrams2Lesson 2:Data Modeling UsingEntity-Relationship Model2003SJSU – CmpE --- M.E. Fayad L2-S3 ER Diagrams Lesson ObjectivesObjectives3 Understand the notation of ERDs Learn how to do ER Analysis Illustrate examples for ERDs2003SJSU – CmpE --- M.E. Fayad L2-S4 ER DiagramsE-R diagrams (ERDs):–Identify major ingredients, entities, of a complicated situation–Identify characteristics, attributes, of the major ingredients–Uncover and analyze interconnections, relationships, among the major ingredients–Assess various aspects of the relationships4What Is Entity-Relationship Diagrams?2003SJSU – CmpE --- M.E. Fayad L2-S5 ER DiagramsERD – Chen 1976Precursor to the class diagram – Will be covered later.No generalizationERD–Entities: Information holding structures–Relationships: Connections between entities–Cardinalities: Upper bounds–Modalities: Lower bounds–Attributes: Properties, characteristics, … associated with an entity.5What Is Entity-Relationship Diagrams?2003SJSU – CmpE --- M.E. Fayad L2-S6 ER DiagramsIn short, ERD strives– to take a close look at the ingredients of a puzzle–in order to identify major and minor ingredients–and to figure out how they relate to each other6What Is Entity-Relationship Diagrams?2003SJSU – CmpE --- M.E. Fayad L2-S7 ER DiagramsERD can be summarized as the process of uncovering, analyzing, and explicating (i.e., stating clearly and fully) the business rules governing a complicated situation7Entity-Relationship Diagrams2003SJSU – CmpE --- M.E. Fayad L2-S8 ER DiagramsBusiness rules are precise statements, derived from a detailed description of the organization's operations, that define one or more of the following modeling components:–Entities–Relationships–Attributes–Connectivities–Cardinalities–Constraints1Rob, P.; Coronel, C. Instructor’s Manual to Accompany Database Systems: Design, Implementation, and Management. Fourth Edition. CD-ROM8Business Rules (1)2003SJSU – CmpE --- M.E. Fayad L2-S9 ER DiagramsExamples of business rules1–An invoice contains one or more invoice lines, but each invoice line is associated with a single invoice. That is,•An invoice contains one or more invoice lines.•Each invoice line is associated with a single invoice.–A store employs many employees, but each employee is employed by only one store.–A college has many departments, but each department belongs to a single college. (This business rule reflects a university that has multiple colleges such as Business, Liberal Arts, Education, Engineering, etc.)1From: Rob, P.; Coronel, C. Instructor’s Manual to Accompany Database Systems: Design, Implementation, and Management. Fourth Edition. CD-ROM9Business Rules (2)2003SJSU – CmpE --- M.E. Fayad L2-S10 ER DiagramsExamples of business rules1 –A driver may be assigned to drive many different vehicles, and each vehicle can be driven by many drivers. (Note: Keep in mind that this business rule reflects the assignment of drivers over a period of time.)–A client may sign many contracts, but each contract is signed by only one client.–A sales representative may write many contracts, but each contract is written by one sales representative 10Business Rules (3)2003SJSU – CmpE --- M.E. Fayad L2-S11 ER DiagramsSome business rules for a library–Books and other materials exist in various editions and numbers of copies–Books may or may not circulate–Books that circulate may do so for varying periods•Periods may be determined by –Book status alone–Borrower status alone–Combination of book status and borrower status11Business Rules (4)2003SJSU – CmpE --- M.E. Fayad L2-S12 ER DiagramsMore business rules for a library•Users may have various statuses•Users may have varying numbers of items currently charged out to them•Users may or may not owe fines–Fine status may or may not affect eligibility to borrow12Business Rules (5)2003SJSU – CmpE --- M.E. Fayad L2-S13 ER DiagramsMore business rules for a library•Staff members have attributes of–Salary or wage rates–Annual leave–Sick leave–Work schedules–Job titles–Special skills (e.g., languages, puppetry)–Hire dates–Total length of service–Professional organization memberships13Business Rules (6)2003SJSU – CmpE --- M.E. Fayad L2-S14 ER DiagramsMore business rules for a library•Physical facilities include–Branches–Furniture–Machines (e.g., computers, microform readers, automobiles, players for CD-ROMs, audiotapes, videotapes)–Library-management software–Catalog records (e.g., computerized databases, catalog cards)–Records of inventory, acquisitions, circulation, personnel14Business Rules (7)2003SJSU – CmpE --- M.E. Fayad L2-S15 ER DiagramsMore business rules for a library•Related organizations may include–City, university, or corporate administrations–Employee unions–Friends of the Library organizations–Vendors of books, serials, and other products and services used by the library–Networks of which the library is a member (e.g., OCLC, Amigos, Association of Research Libraries, Texas State Library network, Central Texas Library System)15Business Rules (8)2003SJSU – CmpE --- M.E. Fayad L2-S16 ER DiagramsE-R analysis relies heavily on diagrams to represent–Entities (rectangles)–Attributes (ellipses)–Relationships (diamonds)–Connections (lines, which may have


View Full Document

SJSU CMPE 226 - Data Modeling

Documents in this Course
SQL-99

SQL-99

71 pages

XML

XML

52 pages

XML

XML

14 pages

Chapter 9

Chapter 9

45 pages

Load more
Download Data Modeling
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view Data Modeling and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Data Modeling 2 2 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?