CS 542 (CS542)

Lecture 4 Objective : Logical Database Design: ER to Relational Step 1: ER Design Step 2: Transform ER Design into Relational Design Step 3: Create tables based on the schemas Step 4: Insert records into the tables that meet the schemas Step 5: Query over the tables to generate the reports

Logical Database Design: ER to Relational Step 1: ER Design Step 2: Transform ER Design into Relational Design Step 3: Create tables based on the schemas Step 4: Insert records into the tables that meet the schemas Step 5: Query over the tables to generate the reports

Logical Database Design: ER to Relational Step 1: ER Design Step 2: Transform ER Design into Relational Design Step 3: Create tables based on the schemas Step 4: Insert records into the tables that meet the schemas Step 5: Query over the tables to generate the reports

Providing a summary of Lecture 2 in DBMS class (CS542). Here we learned about: 1) Understand Users' Requirements, 2). Identify entities, entity sets, attributes, keys, relationships, constraints, etc. 3). Draw the initial Entity Relationship Diagram to capture the above requirements

Providing a deep note about the overview of a database and Why do we need databases?