CASE STUDY Design a database for Tristan College. Tristan C
CASE STUDY Design a database for Tristan College. Tristan College… CASE STUDY 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. Note: Assumptions are allowed and you are allowed to include necessary columns/attributes and tables if it is required. QUESTION 11.1) Draw a Conceptual Diagram based on the case study OutputBrief explanation on the diagram1.2) Design an Entity – Relationship Diagram (ERD) and map the entities with appropriate relationships (ON MY SQL)Output Brief explanation on the diagram1.3) Develop Physical Model Diagram and provide the necessary information for Model (Relational Model – ensure data integrity). (ON MY SQL)Output Brief explanation on the diagram1.4) Use Normalization and make sure your database design isnormalized properly. Computer Science Engineering & Technology MYSQL DATABASE M 201
How it works
- Paste your instructions in the instructions box. You can also attach an instructions file
- Select the writer category, deadline, education level and review the instructions
- Make a payment for the order to be assignment to a writer
- Download the paper after the writer uploads it
Will the writer plagiarize my essay?
You will get a plagiarism-free paper and you can get an originality report upon request.
Is this service safe?
All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades