IDS $410$ Business Database Technology

Individual Assignment #$2($database design$)$

Logical Database Design for a Simple Restaurant System

Due: Submit your solution file to the Blackboard by $11$:$59$ PM on Mon, Feb $7,2022.$

Problem Statement

For this assignment, you are to develop a logical database design $($relational schema$)$ from a conceptual data model $($a simple restaurant data

model$)$ that is given on the last page. Your relations should be normalized to the third Normal form.

Submission

$1.$ A cover page with the following information:

IDS $410$ Business Database Technology

Spring $2022$

Assignment #$2($database design$)$

Logical Database Design for a Simple Restaurant System

Your Name and UIC Email Address

$2.$ A relational schema for a simple restaurant system. Use arrows to show referential integrity constraints. You do not have to show the

functional dependencies among the attributes within a relation $($table$).$ Use a computer$-$based graphic tool to draw your relational schema

$($i$.$e$.,$ LucidChart.com, Creatly.com. gliffy.com, VISIO, etc.$)$