Use ER Assistant to draw your diagram.   Draw a generalization hierarchy containing Employee, Administrator, and Faculty entities.  The Employee entity is the supertype, and the Administrator and Faculty entities are the subtypes.  The Employee entity has attributes as follows:  EmpNo (primary key), EmpName, and EmpAddress.  The Administrator entity has attributes as follows: AdmTitle,  AdmContractLength The Faculty entity has attributes as follows:  FacTenure, FacRank The generalization hierarchy should be disjoint but not complete.

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…

3. Use case model: a. What does a use case diagram depict? b. Create a use case model for a travel agency. This should include all 3 parts of the use case model.

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…