For the table BOOKAUTHOR below you are given the following functional dependencies. BOOKAUTHOR (ISBN, BookTitle, Author_Num, LastName, Publisher, Royalty, Edition) Functional dependencies: 1. ISBN BookTitle, Publisher, Edition 2. Author Num → LastName 3. BookTitle → Publisher 4. {ISBN, Author_Num} → BookTitle, LastName, Publisher, Royalty, Edition Write the types of functional dependencies shown in (1) to (4) above. Also, decompose the table to the third normal from (3NF).

courses dasses ↑coursel INT courseDateTime DATETIME O room INT coursel INT courseName VARCHAR(45) course Description VARCHAR(45) room are used by a class. For each entity: Entitios rooms Froom DVT L-building VARCHAR(X) capacity VARCHAR(45) Inders The ERD depicts the data needed to track which course and Indicate if the entity is strong, weak ID-dependent, or weak non-ID-dependent For each relationship: • List the cardinality and participation of each entity in the relationship List the business rules for each relationship Indicate if the relationship is identifying or not

Please draw an EER diagram for the bank DB system. It requires to design & plan & document a bank system. Your EER model must include supertype and subtypes inheritance associations based on your initial ER model. Relationship constraints and completeness rules (discussed in the EER module) must be included. Requirements: Metadata: define what attributes (data) represent an object (i.e. account type) and data properties (data types, valid range of values, required vs. optional, etc.) Entities (objects): Account owner, dependent (joint family), Checking account, Savings account, Money Market account, loan account, or other banking objects, online account, etc. (suggestion: Define at least 10 entities) Relationships: customer deposit or withdraw money with account, and more. Identify the possible entity sets and their attributes, the relationships among the attributes.