Chapter 1, Problem 2EYW

Using your school's student information system, print your class schedule. The schedule probably would contain the student identification number, student name, class code, class name, class credit hours, class instructor name, the class meeting days and times, and the classroom number. Use Figure P1.11as a template to complete the following actions.

Create Conceptual Models using Draw.io for the following case descriptions:Use a Draw.io blank drawing, and add the relationships from the ER diagram templates group inthe left side panel. Create the three conceptual data Models using Draw.io, export these models as Jpegs, and thenadd all three models in an MS Word document and submit that MS Word file with all three images(of data models in it) through Blackboard submission link before the deadline. 1. You have been asked to design a database that would store data for ABC Company, whichis a small online retailer. ABC would like to store data about its customers, orders, items,couriers. Each customer may place multiple orders. An item may be part of many ordersand order typically contains multiple items. Each order is shipped via one of thecouriers (parcel companies) and ABC Inc. has contracts with several couriers for shippingits customer orders. 2. ABC College has many departments and each department offer courses. Some…

Normalize the following from UNF to 3NF.   Animal_Adoption (AdoptionID, AdoptionDate, ICNo, FirstName, LastName, Contact, {AnimalID, AnimalName, AnimalType, AnimalRescueDate})