My topic; Accounting Database and Managing System Issue: My brother works as an accountant in a firm named as stainless steel. The firm's accountants having a problems of tracking and managing the incomes of the company and how many materials are needed for each product. I drew the ER map wrong. Could you please draw it as EER in detail? Get more attributes. Including Foreign keys , Multivalued attributes, Derived attribute, Composite attributes. My draw: Customer id phone -Purchase---- product - Made by id type price details name Adress Country City Attribute7 name made payment -For id amount data which gives raw materials Id Price profit Employee ----manages -- ---manages ---- id Name id Date name Details Available Quanti phone Surname Adress Start_Date amount +--

“Martial Arts R Us” (MARU) needs a database. MARU is a martial arts school with hundreds of students. The database must keep track of all the classes that are offered, who is assigned to teach each class, and which students attend each class. Also, it is important to track the progress of each student as they advance. 1.Create a complete Crow’s Foot ERD for these requirements: 2.Create a relational diagram for the data model. 3.Draw the dependency diagram showing partial and transitive dependency(if any). 4. Normalize the tables to 3NF. 5. Show the dependency diagram after normalization. 6. Use SQL to create all tables in Access. Do not forget FK,PK 7. Create relationships.

Given the ER diagram below, create relation schemas to capture the database design.

T. Relational Model Instructions This assignment will show that you understand how columns should be separated between tables in a properly structured relational database. Your objective: Imagine you need to design a database that tracks members, type of membership, and exercise routines for each member. • Build a relational database model with multiple tables • Use your imagination and feel free to create the tables with as many columns as you would like. • Highest points will be awarded for completeness AND correctness. Submit as an Excel workbook or image.

using the design file in the image attached to the question : Normalize the database in the design file Be aware of the possibility of duplicate data. Name in Role and Employee and Emp_Contact_name all refer to the same data. Name and Email in Vendor refer to the Vendor. Assumptions made: An employee works with one or more vendors. An employee may have none or many dependents. An employee may have many roles over the employee's work history and a record should be retained for each role.

Provide an example of a Key Attribute.