Database Management Systems Lecture 2

Database Management Systems Lecture 2 - Database Management...

Info icon This preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
Database Management Systems Relational Database Concepts Saiwu Lin E. Philip Saunders College of Business Rochester Institute of Technology Email: [email protected]
Image of page 1

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

View Full Document Right Arrow Icon
Objectives Describe the relational model Understand entity, attribute, relationship Understand entity integrity, referential integrity 2
Image of page 2
Relational Database A relational database is a collection of tables An entity is a person, place, event, or thing for which we intend to collect data. University -- Students, Faculty Members, Courses Each entity has certain characteristics known as attributes . Student -- Student Number, Name, GPA, Date of Enrollment, Data of Birth, Home Address, Phone Number, Major Each entity is stored in its own table Attributes of an entity become the fields or columns in the table 3
Image of page 3

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

View Full Document Right Arrow Icon