CSC 4710 / CSC 6710Database SystemsRao Casturi*Material based on Fundaments of DATABASE SYSTEMS 7th. Edition (Elmasri & Navathe) ** Additional comments, slides are added by Rao CasturiWhen needed we will use them
SUMMARY Data Modeling Using the Entity-Relationship (ER) ModelRao 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 Degree2
Terms which can helpRao Casturi - GSU - Database Systems3
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 designRao Casturi - GSU - Database Systems5
Some of the Automated Database Design Tools (Note: Not all may be on the market now)COMPANYTOOLFUNCTIONALITYEmbarcadero TechnologiesER StudioDatabase Modeling in ER and IDEF1XDB ArtisanDatabase administration, space and security managementOracleDeveloper 2000/Designer 2000Database modeling, application developmentPopkinSoftwareSystem Architect 2001Data modeling, object modeling, process modeling, structured analysis/designPlatinum (Computer Associates) Enterprise Modeling Suite: Erwin, BPWin, Paradigm PlusData, process, and business component modelingPersistence Inc.PwertierMapping from O-O to relational modelRational (IBM)Rational RoseUML Modeling & application generation in C++/JAVAResolution Ltd.XcaseConceptual modeling up to code maintenanceSybaseEnterprise Application SuiteData modeling, business logic modelingVisioVisio EnterpriseData modeling, design/reengineering Visual Basic/C++Rao Casturi - GSU - Database Systems6
ER Diagram - Naming standards•As a general practice, given a narrative description of the database requirements, the nounsappearing in the narrative tend to give rise to entity type names •Verbstend to indicate names of relationship types. •Attribute names generally arise from additional nouns that describe the nouns corresponding to entity types.