Note: Create Book and Author tables as below and solve relationship using MySQL Workbench Data Model (ERD). DDL generati
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
Note: Create Book and Author tables as below and solve relationship using MySQL Workbench Data Model (ERD). DDL generati
Note: Create Book and Author tables as below and solve relationship using MySQL Workbench Data Model (ERD). DDL generation NOT NEEDED. 1. A Book can be written by several Authors 2. An Author can write several Books Assumption: Each book must have an author and each author must write a book. Book BookID INT >Title VARCHAR(45) >Publisher VARCHAR(45) >Price DECIMAL (10,2) Indexes PRIMARY Author AuthorID INT >AuthorName VARCHAR(45) > Address VARCHAR(45) ◇DOB DATE Indexes PRIMARY