Question: (a) Draw ER diagram using MySQL WB based on the logical library database schema you (b) Populate at least 7 tuples for each table of
(a) Draw ER diagram using MySQL WB based on the logical library database schema you (b) Populate at least 7 tuples for each table of the library database table schema (Use insert (c) Generate DDL scripts (SQL scripts) to create library database and database tables. Then (d) Write SQL statements to retrieve data from the library database explained in the derived from the conceptual model (mapping done in Assignment 1). SQL statement). create library database in MySQL DBMS. following statements (1 to 7). We assume the name of the branch, and the book title, etc are assumed the data populated in your database tables
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
