Answer Happy

Case Study: A database system for Tristan College. Design a database for Tristan College. Tristan College offers various programs and currently has many students. The college wants to organize its data. You are required to design the database. Many students seek admission in the college. The college has a number of departments and students can be enrolled to these departments. The department also offers a number of courses to the students, each with a different duration from the other. Each department has its H.O.D and many teachers under him. The syllabus of each course is also defined. Teachers are recruited by the college for teaching the said courses to the students. The teachers may have different qualifications and experience. They may also teach different subjects if required. Each student in the college has a unique ID. We need to store the names of the students studying in the college, their residential address, date of birth. We also need to store information about the college like the name, address, contact number, reference ID, departments of the college, name of the H.O.D, number of teachers and students in the department. Also, the courses offered by the departments, the syllabus, the duration and the course ID. We can also store information about the teachers like their qualification, experience, name and subjects taught. No. Task Draw a Conceptual Diagram based on the case study 1 • Output Brief explanation on the diagram 2 Note: Assumptions are allowed and you are allowed to include necessary columns/attributes and tables if it is required. 3 For the above mentioned business details, you should do the following tasks. Design an Entity-Relationship Diagram (ERD) and map the entities with appropriate relationships Output Brief explanation on the diagram Develop Physical Model Diagram and provide the necessary information for Model (Relational Model-ensure data integrity). *Output Brief explanation on the diagram Use Normalization and m 4 normalized properly sure your design is Marks 20 30 30 20
PART A Criteria Q1: Conceptual Diagram Q2: Entity- Relationship Diagram (ERD) Q3: Physical Model design 04: Normal Excellent >90% of the marks The conceptual diagram is valid and acceptable. The entities and associated links are designed correctly. The justifications and descriptions are accurate, clear, and valid. The similarity is less than 2% The Physical Model diagram valid and acceptable. The entities and associated links are designed correctly. The justifications and descriptions are accurate, clear, and valid. The similarity is less than 2% The ERD diagram is valid and acceptable The entities and associated links are designed correctly. The justifications and descriptions are accurate, clear, and valid. The similarity is less mistakes. The than 2%. similarity is less than 4%. is Score The answer is correct. The justification is accurate, clear, and valid. The similarity is less than 2% Good <90% to 75% of the marks The conceptual diagram is valid and acceptable. The entities and associated links are designed with minor mistakes OR the justifications and descriptions has a few minor mistakes. The similarity is less than 4%. The ERD diagram is valid and acceptable. The entities and associated links are designed with minor mistakes OR the justifications and descriptions has a few minor Average <75% to >= 40 of the The answer is correct. The justification is acceptable but not well written. The similarity is less than 4%. Poor <40 of the marks marks The conceptual diagram is acceptable with minor mistakes. The entities and associated links are designed with minor mistakes OR the justifications and justifications and descriptions has a descriptions has a few minor mistakes. The few major similarity is less than 5%. The Physical Model diagram is acceptable with minor mistakes. The entities and associated links are designed with minor mistakes OR the The conceptual diagram is acceptable with major mistakes. The entities and associated links are designed with major mistakes AND the mistakes. The similarity is more than 5% The ERD The ERD diagram is acceptable with minor mistakes. The entities and associated links are designed with minor mistakes OR the justifications and diagram is acceptable with major mistakes. The entities and associated links are designed with major mistakes AND the justifications and descriptions has a descriptions has a few minor mistakes. The similarity is less than 5% few major mistakes. The similarity is more than 5% The Physical Model diagram is The Physical Model diagram is valid and acceptable. The entities and associated links are designed with minor mistakes OR the justifications and acceptable with major mistakes. The entities and associated links are designed with major mistakes AND the justifications and justifications and descriptions has a descriptions has a descriptions has a few minor mistakes. The i similarity is less than 4%. few minor mistakes. The similarity is less few major mistakes. The similarity is more than 5% than 5%. The answer is correct. But the justification is not well written, The similarity less than 5%. The answer is not correct. The justification is not accurate, not clear, and not valid. The similarity is more than 5%.