PPT-1 Entity Relationship Modeling

2 Outline Data Modeling Big picture ER Model Attributes types Relationships connectivity cardinality strength participation degree Entities composite entity supertypesubtype Table Normalization. Part 1 provided a brief overview of the ER approach and then covered the basics of the Barker ER notation 1 that has long been supported in CASE tools from vendors such as Oracle Corporation In this notation entity types are depicted as named soft r Joe Meehean. 1. Entity Relationship Model. Entity type. an object (noun). e.g., student. attributes (e.g., last name). Relationship. association between entity types. bidirectional relationship between entities. System. s. Analysis. Structured analysis. Karolina . Muszyńska. Based partly on: http://www.csun.edu/~dn58412/IS431/IS431_SP13.html. Model-driven Analysis. Structured analysis. Information engineering. Entity. “An . entity. is a business object that represents a group, or category of data.”. 1. Do we know a similar concept? . 1) Stephens, R.K. and Plew. R.R., 2001. . Database Design. . SAMS, Indianapolis , IN.. Man is a knot, a web, a mesh into which relationships are tied. Only those relationships matter. Saint-Exupéry. Data modeling. A technique for modeling data. A graphical representation of a database. Mussbacher. , . Gregor. v. . Bochmann. , . with . material from:. K.E. . Wiegers. , D. . Leffingwell. & D. . Widrig. , M. Jackson, I.K. Bray, B. . Selic. , . Volere. , . Telelogic. , D. Damian, S. . Chapter 2. Overview of Database Design. Conceptual design. : . (. ER Model . is used at this stage.) . What are the . entities. and . relationships. in the enterprise. ?. Students . sign up. . for . Modeling:. 1. CIS . 4365 . Entity Relationship Diagrams. Part 2. Your Individual Project. 2. CIS 4365 . Entity . Relationship Diagrams. We will develop the ERD as a class; you must execute complete the project . Data Modeling What are you keeping track of? You begin to develop a database by deciding what you are going to keep track of. Each “thing” that you are want to keep track becomes an entity in your database. Data Management 02 Conceptual Design Matthias Boehm Graz University of Technology, Austria Computer Science and Biomedical Engineering Institute of Interactive Systems and Data Science BMVIT endowed chair for Data Management Chapter Five: Data Modeling with the Entity-Relationship Model Chapter Objectives To understand the two-phase data modeling/database design process To understand the purpose of the data modeling process 2. Organization. :ER Case Study. Organization made up of various departments, each having a name, identifying no., and an employee who is the manager. A department may be located in different places. Information about employee includes name, identification number, birth date, address, sex, and salary. Each employee is assigned to one department. The date the manager is appointed to a department is also tracked. Employees may be directly supervised by another employee. Each project within the organization is controlled by a department. Employees (not necessarily from the controlling dept.) are assigned to projects. Information about projects includes project name, no., and location. Hours spent by employees on each project are also kept.. Cal Poly Pomona. Overview of Database Design Process. Two main activities:. Database design. Applications design. Focus in this chapter on . conceptual database design. To design the conceptual schema for a database application. Queries . Using . an . Extended . Graph Model. Ankur. . Agrawal. . S. Sudarshan . Ajitav. . Sahoo. . Adil. . Sandalwala. . Prashant. . Jaiswal. . IIT . Bombay. History of Keyword Queries.