Draw an E-R diagram for a bank.  It should include at least customers, checking accounts and loans, and appropriate relationships between them. Note: To keep this to a resonable size, you should limit yourself to at most six entities and at most eight attributes per entity.

Draw an ER diagram with the following data: Entities: Student, Exam, Course ⚫ Relationships: • Student takes at least one exam o An exam is given to at least one student. 。 An exam concerns only one course o A course has a least one exam ■ Attributes: Stud_Roll No, Stud Name, Stud Age, Course_No, Course_Name, Course Hours, Exam_No, Exam date, Exam Duration, Exam_Mark.

Prepare an E-R diagram for a real estate firm that lists property for sale. Identify all entities (supertype/subtype), attributes (optional/required), unique identifiers, relationships and relationships cardinality and optionality. Resolve any M-M relationship you find. • The firm has several sales offices in several states. Each sales office has Office_Number and a Location. • Employees are assigned to work in different sales offices. Each employee has an ID and Name. • An employee must be assigned to only one sales office. For each sales office, there is always one employee assigned to manage that office. For each manager we record the start date of the management job. • The firm lists properties for sale. Each property has an ID, description and Location. Each unit of property must be listed with one (and only one) of the sales offices. A sales office may have any number of properties listed. • Each unit of property has one or more owners. owners have ID and Name. An owner may own…

Design the UML class diagram to support the system below and upload a picture of your diagram. Used Class Material Website: You are designing a website where students can resale their used material for a course.   A course may have multiple sections.  The course material is specific to each section of a class. Not all course may require class materials, but they may require many of them. A student can have many used materials for sale. The class material can be either:   ·       Textbook: which has a price(mandatory), title(mandatory), authors(optional), edition(optional) ·       Software: which has a price(mandatory), title(mandatory), publisher(optional), and also its operating system (mandatory) ·       Equipment:  which has a price(mandatory), title(mandatory), description(mandatory) All class material can be either available or sold. Do a class diagram with: 1.     all the classes , 2.     their associations  3.     their multiplicity .    4.     For each classes, where are the…

Q1. Draw an E-R Diagram for the following situation. At the university system each STUDENT must be assigned an ADVISOR who counsels students about degree requirements and helps students register for classes (COURSE). Each student must register (REGISTRATION) for classes with the help of an advisor, but if the student's assigned advisor is not available, the students may register with any advisor, We must keep track of students, the assigned advisor for each, and the name of the advisor with whom the students registered for the current term. Tips: Attributes of STUDENT include Student ID (the identifier), Name, and Major. Attributes of ADVISOR include Advisor ID (the identifier), Name, and Department. Attributes of COURSE include Course ID (the identifier), Title, and Credits. Attributes of REGISTRATION include Semester, and Year. Based on your background, think of logical and standard relationships between the given entities.

b) An ER/EER diagram modeling your database (use appropriate symbols, and don’t forgetassociative entities where appropriate). This will be based on the business rules you created, somake sure you’ve written clear rules! (30 points)• Feel free to use an appropriate design tool you would like for your ER diagram (e.g.http://draw.io), or do it by hand and scan it in; just make sure it is legible and that itfollows the notation/style taught in class. Do NOT use other styles, such as “Visio”notation that includes PK/FK.c) A list of normalized relations (using the notation from class) that is based on your ER diagram.Be sure to include foreign keys, etc. (30 points)

Please help me answer the following questions

What is the difference between a recurring group and an attribute that may take on many values?

What is the concept in which the entity(variable) and its attributes(type) are associated during the execution time? Mention one of its disadvantage.

Draw three sequence diagrams for three use cases in the use case diagram attached. Please draw the sequence diagram similar to the attatched second photo.