er_prac - Entity-Relationship Model [ER Model] OUTLINE...

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

View Full Document Right Arrow Icon
Entity-Relationship Model [ER Model]
Background image of page 1

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

View Full DocumentRight Arrow Icon
OUTLINE b Overview of Database models b ER Diagram for COMPANY Schema b Constraints b Structural Constraints
Background image of page 2
Overview of Database Design Process b Two main activities: s Database design s Applications design b Focus in this session on database design o design the conceptual schema for a database application s To design the conceptual schema for a database application b Applications design focuses on the programs and interfaces that access the database s Generally considered part of software engineering
Background image of page 3

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

View Full DocumentRight Arrow Icon
Overview of Database Design Process
Background image of page 4
b The company is organized into DEPARTMENTs. Each department has a name, number and an employee who manages the department. We keep track of the start date of the department manager. ach department ntrols number of PROJECTs ach project b Each department controls a number of PROJECTs . Each project has a name, number and is located at a single location. b Store each EMPLOYEE’s social security number, address, salary, sex, and birthdate. Each employee works for one department but may work on several projects. We keep track of the number of hours per week that an employee currently works on each project. We also keep track of the direct supervisor of each employee. b
Background image of page 5

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

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

This note was uploaded on 04/01/2012 for the course CSE,IT 101 taught by Professor Mirunaalini during the Spring '12 term at Indian Institute of Technology, Chennai.

Page1 / 19

er_prac - Entity-Relationship Model [ER Model] OUTLINE...

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

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