Week 2
Post date: Sep 08, 2019 3:42:38 AM
Chapter 3: The Relational Data Model and Relational Database Constraints
Relational model concepts
Relational model constraints and relational database schemas
Update operations, transactions, and dealing with constraint violations
Online Tools:
In-class Exercises:
Ex 1:
Group the following attributes in entities and show the relationships between the different entities:
Product ID
Invoice ID
Product Name
Product Quantity
Customer Name
Customer Phone number
Invoice Date
Product Price
Ex 2:
Using the following entities, draw an Entity-Relationship diagram for a typical University situation:
Student
Course
Section
Department
Faculty
Grade