Question

1. Draw an ERD for the following situation. Be sure to show: entity information, attributes, identifier(s), relationships and relationship names, and cardinality Each publisher has a unique name; a mailing address and telephone number are also kept on each publisher. A publisher may publish one or more books; a book is published by exactly one publisher. A book is identified by its ISBN, and other attributes are title, price, and number of pages. Each book is written by one or more authors; an author may write one or more books, potentially for different publishers. Each author is uniquely described by an author ID, and we know each author's name and address. As you develop the ERD for this problem, follow good data naming guidelines. 2. Draw a complete EERD for the following situation. Assume an entity named EMPLOYEE. The entity employee has some attributes empID, Name, Birth Date, Age. There are different type of employees including Accountants, Mechanics, and Pilots. An accountant has a CPA (Certified Public Accountant) qualification that no other employee type has. A pilot has a flying qualification and a pilot license that no other employee has. A mechanic has a qualification of aircraft engineering that no other employee has.

Answer 1

Telephme- numbs SBN Norme tte ubus Boo Mai th pr Authors Narre

Emplojee IS A Accountamb Mechaice PiLot Pilot_lumse