CS3120 Database Management Systems Laboratory Assignment – 2

$35.00

Download Details:

  • Name: lab2-tm3lvw.zip
  • Type: zip
  • Size: 1.00 MB

Category:

Description

5/5 - (1 vote)

Assignment:
1. Identify at least 5 entity sets and 3 relationship sets to create a DBMS for
a restaurant.
2. Construct a neat Entity Relationship Diagram for the same using any
diagram design tool. Hand-drawn diagrams will not be accepted.
3. Use MariaDB :
a. Create a database Restaurant
b. Create all the required tables
c. Show all tables in the database
d. Show structure of the tables created in question 3(b)