Note: Create Book and Author tables as below and solve relationship using MySQL Workbench Data Model (ERD). DDL generati
Posted: Fri Jul 08, 2022 6:44 am
- Note Create Book And Author Tables As Below And Solve Relationship Using Mysql Workbench Data Model Erd Ddl Generati 1 (124.65 KiB) Viewed 38 times
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