Chap04 - CSC 4710 CSC 6710 Database Systems When needed we will use them*Material based on Fundaments of DATABASE SYSTEMS 7th Edition(Elmasri

Chap04 - CSC 4710 CSC 6710 Database Systems When needed...

This preview shows page 1 - 8 out of 66 pages.

CSC 4710 / CSC 6710 Database Systems Rao Casturi *Material based on Fundaments of DATABASE SYSTEMS 7 th . Edition (Elmasri & Navathe) ** Additional comments, slides are added by Rao Casturi When needed we will use them
SUMMARY Data Modeling Using the Entity-Relationship (ER) Model Rao Casturi - GSU - Database Systems Overview of Database Design Process Example Database Application (COMPANY) ER Model Concepts Entities and Attributes Entity Types, Value Sets, and Key Attributes Relationships and Relationship Types Weak Entity Types Roles and Attributes in Relationship Types ER Diagrams - Notation ER Diagram for COMPANY Schema Alternative Notations – UML class diagrams, others Relationships of Higher Degree 2
Terms which can help Rao Casturi - GSU - Database Systems 3
Rao Casturi - GSU - Database Systems 4 One – To- One One – To- Many Many – To- Many
Data Modeling Tools (Additional Material ) A number of popular tools that cover conceptual modeling and mapping into relational schema design. Examples: ERWin, S- Designer (Enterprise Application Suite), ER- Studio, etc. POSITIVES: Serves as documentation of application requirements, easy user interface - mostly graphics editor support NEGATIVES: Most tools lack a proper distinct notation for relationships with relationship attributes Mostly represent a relational design in a diagrammatic form rather than a conceptual ER-based design Rao Casturi - GSU - Database Systems 5
Some of the Automated Database Design Tools (Note: Not all may be on the market now) COMPANY TOOL FUNCTIONALITY Embarcadero Technologies ER Studio Database Modeling in ER and IDEF1X DB Artisan Database administration, space and security management Oracle Developer 2000/Designer 2000 Database modeling, application development Popkin Software System Architect 2001 Data modeling, object modeling, process modeling, structured analysis/design Platinum (Computer Associates) Enterprise Modeling Suite: Erwin, BPWin, Paradigm Plus Data, process, and business component modeling Persistence Inc. Pwertier Mapping from O-O to relational model Rational (IBM) Rational Rose UML Modeling & application generation in C++/JAVA Resolution Ltd. Xcase Conceptual modeling up to code maintenance Sybase Enterprise Application Suite Data modeling, business logic modeling Visio Visio Enterprise Data modeling, design/reengineering Visual Basic/C++ Rao Casturi - GSU - Database Systems 6
ER Diagram - Naming standards As a general practice, given a narrative description of the database requirements, the nouns appearing in the narrative tend to give rise to entity type names Verbs tend to indicate names of relationship types. Attribute names generally arise from additional nouns that describe the nouns corresponding to entity types.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture