Please convert this EERD to RELATION. Thanks! Use arrow to identify the foreign key, not only box and tell where is the foreign key. Draw it in paper, thanks!!!

Use C# to create Order class as follows: a. Data members: oid, orderDate, promised Date, shipDate, deliveryDate, amount, status. b. Behavioral members: isOnTime() - check if the delvieryDate is ahead of promised Date, timeToDelivery() - get number of days from order to delivery, getLate Fees() - company pays 1% fee to the customer for every day of delay in delivery according to the contract.

Question 53 Creating a class involves creating new instancesof objects defining class attributes changing values of calss attributes doing operations on class instances

add member function Signature: Complex add(const Complex &addComplex) const Returns a new Complex object that is this object added by the specified object. Formula: (a + bi) + (c + di) = (a + c) + (b + d)i New Real: (a + c) New Imaginary: (b + d) subtract member function Signature: Complex subtract(const Complex &subtractComplex) const Returns a new Complex object that is this object subtracted by the specified object. Formula: (a + bi) - (c + di) = (a - c) + (b - d)i New Real: (a - c) New Imaginary: (b - d) multiply member function Signature: Complex multiply(const Complex &multiplyComplex) const Returns a new Complex object that is this object multiplied by the specified object. Formula: (a + bi) * (c + di) = (a*c - b*d) + (b*c + a*d)i New Real: (a*c - b*d) New Imaginary: (b*c + a*d) divide member function Signature: Complex divide(const Complex &divideComplex) const Returns a new Complex object that is this object divided by the specified object.…

Digital Wallet: the access control rule for the class Transaction and boundary use case for the entity class Transaction

STORY BOOK # Id * Name * Published date o Publisher * Type Find the error in the given ERD written by write O g. Novel name is multivalued attribute Oh. Type attribute must be in AUTHOR side O i. Cardinalities of relationships are not correct AUTHOR # Id * Name * Surname o Age O a. There is a volatile attribute and it must be converted to nonvolatile attribute O b. "Published date" and "Publisher" attributes are violating 3NF O c. Name attribute cannot be used in both entities since it is not allowed to have same name O d. Name of the "STORY BOOK" must be written as "STORY_BOOK" O e. Optionality of relationship in AUTHOR side cannot be mandatory O f. "Surname" attribute can be optional

Question 02: Write five examples of each of the following from real life also draw UML of each example.1. Association2. Aggregation3. Composition

Please no written by hand solution DEFINING BUSINESS RULES FOR A VIDEO RENTAL STORE Think about how your local video rental store works. There are many customers, renting many videos, and many videos sit on the shelves unrented. Customers can rent many videos at one time. And some videos are so popular that the video rental store keeps many copies. Write down all the various business rules that define how a video rental store works with respect to entity classes and their relationships.

QUESTION 1 Happy Learning (this is a fictional scenario) A private kindergarten, Happy Learning, wants to build a database to manage their operations. You were assigned to create an initial design based on the following customer description of their operations. There are 3 age levels in the kindergarten (turtles, foxes and monkeys). At each level there 3 classes (red, blue and green). For a class we keep a code based on the initial of group color and level (e.g. RT for red turtles, GF for green foxes). Each class has a room number and a phone number (with the format (999) 9999999). Also, each class has a maximum capacity (between 25 and 35). For some classes we will keep brief directions to the class location in the building (less than 160 characters). For a student we will keep the name (first, last, middle each less than 15 characters), any nickname (less than 10 characters), date of birth, address, and the class in which the student is currently enrolled. We will process…

Q3:Design UML for the following set of requirements for a universitydatabase that is used keep track of student’s transcripts.1. The university keeps track of each student’s name, student number,social security number, current address and phone, permanentaddress and phone birthdate, sex, major department, minordepartment (if any), and degree program (B.A., B.S., Ph.D.). Bothstudent number and social security number have unique values foreach student.2. Each department is described by a name, department code, officenumber office phone, Both name end code have unique values foreach department3. Courses are described by a course name, course number, credithours and department. each course has one or more prerequisitecourse.4. Each section has an instructor, semester (spring) , year , course ,and section number. The section number is unique.5. A grade report needs to be printed out to display the studentnumber, the section and the numeric grade