please solve this thankyou

please make the conceptual model and the logical model Thankyou

The Technology and Engineering college decides to develop a scheduling system. The development team started working on the project. There are three groups in the team working on the front end, the back end, and the database, respectively. The database analyst had meetings with the project stakeholders (management, teaching staff and tech support) and developed the following database business rules: There are 3 faculties in the college (management, IT, and engineering) Each faculty consists of several departments All courses (units) provided by the College are unique All employees involved in the teaching process are divided into three groups: technicians, administrators, and lecturers The technicians provide a support for the College website, computer and engineering labs, and the College network The administrators are receptionists, student support officers, course advisors, assistants, coordinators etc. Each lecturer belongs to one department A Faculty Dean is a lecturer A Head of a Department is also a lecturer Each student belongs to one Faculty To take a course, a student needs to enrol in a There can be several classes for a course A room is assigned for each class A building is associated with each room The college database stores the following common information about employees: employee ID, first name, last name, address, email, and phone number For the tech staff the database stores a position name and skills (there can be multiple skills for a tech person: network, hardware, software, database, and website support etc.) An admin position name is stored as an attribute for the administrators A specialty and a rank are stored for the lecturers The Faculty attributes are the faculty ID and faculty name The Department attributes are the department ID and department name The Student attributes stored in the database are student ID, first name, last name, email, and phone number The course attributes are course ID, title, and description The class attributes are class ID, and time The room attributes are room ID, capacity, and type (lecture room, computer lab, or engineering lab) The building attributes are building ID and location A student can be enrolled in several classes. When a student enrols in a class then an enrolment date associated with the class is also stored A student can also be employed as a tech staff in the College. He/she can do various jobs like database admin, code development, web development, system help, software installation, hardware and network setup etc. You must submit your assignment as a MS Word document. The diagrams must be drawn using app.diagrams.net online tool, saved as.png or .jpg file and inserted in the Word assignment document. Don't forget to include the assignment cover sheet !!! Part 1. Conceptual Model Please remember that the Enhanced Entity-Relationship diagram is only a part of your assignment. You need to describe the Conceptual Model, which must include the following elements: Entities and their attributes. For each entity you must also specify unique identifier attribute(s) Entity supertypes and subtypes. Describe inheritance types and the corresponding discriminators. Identify multi-valued and composite attributes (if any). In this case, they need to be shown in the ER diagram with the corresponding notations. Describe relationships between entities and their cardinalities. Remember that relationships can be one-to-one, one-to-many, many-to-many, and also optional or mandatory Draw the Conceptual Model Enhanced Entity-Relationship diagram using app.diagrams.net tool, save it as .png or .jpg file and insert it in the Word document The Technology and Engineering college decides to develop a scheduling system. The development team started working on the project. There are three groups in the team working on the front end, the back end, and the database, respectively. The database analyst had meetings with the project stakeholders (management, teaching staff and tech support) and developed the following database business rules: There are 3 faculties in the college (management, IT, and engineering) Each faculty consists of several departments All courses (units) provided by the College are unique All employees involved in the teaching process are divided into three groups: technicians, administrators, and lecturers The technicians provide a support for the College website, computer and engineering labs, and the College network The administrators are receptionists, student support officers, course advisors, assistants, coordinators etc. Each lecturer belongs to one department A Faculty Dean is a lecturer A Head of a Department is also a lecturer Each student belongs to one Faculty To take a course, a student needs to enrol in a There can be several classes for a course A room is assigned for each class A building is associated with each room The college database stores the following common information about employees: employee ID, first name, last name, address, email, and phone number For the tech staff the database stores a position name and skills (there can be multiple skills for a tech person: network, hardware, software, database, and website support etc.) An admin position name is stored as an attribute for the administrators A specialty and a rank are stored for the lecturers The Faculty attributes are the faculty ID and faculty name The Department attributes are the department ID and department name The Student attributes stored in the database are student ID, first name, last name, email, and phone number The course attributes are course ID, title, and description The class attributes are class ID, and time The room attributes are room ID, capacity, and type (lecture room, computer lab, or engineering lab) The building attributes are building ID and location A student can be enrolled in several classes. When a student enrols in a class then an enrolment date associated with the class is also stored A student can also be employed as a tech staff in the College. He/she can do various jobs like database admin, code development, web development, system help, software installation, hardware and network setup etc. You must submit your assignment as a MS Word document. The diagrams must be drawn using app.diagrams.net online tool, saved as.png or .jpg file and inserted in the Word assignment document. Don't forget to include the assignment cover sheet !!! Part 1. Conceptual Model Please remember that the Enhanced Entity-Relationship diagram is only a part of your assignment. You need to describe the Conceptual Model, which must include the following elements: Entities and their attributes. For each entity you must also specify unique identifier attribute(s) Entity supertypes and subtypes. Describe inheritance types and the corresponding discriminators. Identify multi-valued and composite attributes (if any). In this case, they need to be shown in the ER diagram with the corresponding notations. Describe relationships between entities and their cardinalities. Remember that relationships can be one-to-one, one-to-many, many-to-many, and also optional or mandatory Draw the Conceptual Model Enhanced Entity-Relationship diagram using app.diagrams.net tool, save it as .png or .jpg file and insert it in the Word document