Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
The School of Innovative Technologies and Engineering (SITE) wishes to develop an MIS to keep track of students doing their Final year project or undergoing Industrial Internship (Placement). You have been asked to develop a high-level data model based on the following findings. A student undergoes his internship either on 2nd level or 3rd level depending on the duration of the programme. On the final year he/she undertakes a project. For the internship, a student chooses a topic from a list of topics suggested by private companies. The internship is supervised by both an academic from SITE and a staff from the company chosen. At the end of the internship the student is required to submit a report which is marked by both the SITE academic and the Industrial supervisor. In the final year a student selects a project title from a list of titles suggested by SITE academics or they are free to propose a title on their own. After consultation with an identified academic and upon agreement of both parties the student may be allowed to undertake the title he suggested. At the end of 9 months the student submits a report and does a presentation, on which he is marked. While academic may be supervising a student, he/she might also be his/her tutor. An academic can be the tutor of one or more students but a student has only one tutor. A student can undertake only one project and a project is carried out by only one student. Similarly a student can undergo only one internship but a company can allow a maximum of three students to undergo internship. In the company the industrial supervisor can supervise a maximum of three students for their internship while the student is supervised by one industrial supervisor and an academic from SITE. (a) Produce an Entity Relationship Diagram (Logical Data Structure) for the above scenario. For each entity list the attributes and the respective primary key. (b) Translate your ERD into a relational database schema

The School of Innovative Technologies and Engineering (SITE) wishes to develop an MIS to keep track of students doing their Final year project or undergoing Industrial Internship (Placement). You have been asked to develop a high-level data model based on the following findings. A student undergoes his internship either on 2nd level or 3rd level depending on the duration of the programme. On the final year he/she undertakes a project. For the internship, a student chooses a topic from a list of topics suggested by private companies. The internship is supervised by both an academic from SITE and a staff from the company chosen. At the end of the internship the student is required to submit a report which is marked by both the SITE academic and the Industrial supervisor. In the final year a student selects a project title from a list of titles suggested by SITE academics or they are free to propose a title on their own. After consultation with an identified academic and upon agreement of both parties the student may be allowed to undertake the title he suggested. At the end of 9 months the student submits a report and does a presentation, on which he is marked. While academic may be supervising a student, he/she might also be his/her tutor. An academic can be the tutor of one or more students but a student has only one tutor. A student can undertake only one project and a project is carried out by only one student. Similarly a student can undergo only one internship but a company can allow a maximum of three students to undergo internship. In the company the industrial supervisor can supervise a maximum of three students for their internship while the student is supervised by one industrial supervisor and an academic from SITE. (a) Produce an Entity Relationship Diagram (Logical Data Structure) for the above scenario. For each entity list the attributes and the respective primary key. (b) Translate your ERD into a relational database schema

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question
The School of Innovative Technologies and Engineering (SITE) wishes to develop an MIS to keep track of students doing their Final year project or undergoing Industrial Internship (Placement). You have been asked to develop a high-level data model based on the following findings. A student undergoes his internship either on 2nd level or 3rd level depending on the duration of the programme. On the final year he/she undertakes a project. For the internship, a student chooses a topic from a list of topics suggested by private companies. The internship is supervised by both an academic from SITE and a staff from the company chosen. At the end of the internship the student is required to submit a report which is marked by both the SITE academic and the Industrial supervisor. In the final year a student selects a project title from a list of titles suggested by SITE academics or they are free to propose a title on their own. After consultation with an identified academic and upon agreement of both parties the student may be allowed to undertake the title he suggested. At the end of 9 months the student submits a report and does a presentation, on which he is marked. While academic may be supervising a student, he/she might also be his/her tutor. An academic can be the tutor of one or more students but a student has only one tutor. A student can undertake only one project and a project is carried out by only one student. Similarly a student can undergo only one internship but a company can allow a maximum of three students to undergo internship. In the company the industrial supervisor can supervise a maximum of three students for their internship while the student is supervised by one industrial supervisor and an academic from SITE. (a) Produce an Entity Relationship Diagram (Logical Data Structure) for the above scenario. For each entity list the attributes and the respective primary key. (b) Translate your ERD into a relational database schema
Transcribed Image Text:The School of Innovative Technologies and Engineering (SITE) wishes to develop an MIS to keep track of students doing their Final year project or undergoing Industrial Internship (Placement). You have been asked to develop a high-level data model based on the following findings. A student undergoes his internship either on 2nd level or 3rd level depending on the duration of the programme. On the final year he/she undertakes a project. For the internship, a student chooses a topic from a list of topics suggested by private companies. The internship is supervised by both an academic from SITE and a staff from the company chosen. At the end of the internship the student is required to submit a report which is marked by both the SITE academic and the Industrial supervisor. In the final year a student selects a project title from a list of titles suggested by SITE academics or they are free to propose a title on their own. After consultation with an identified academic and upon agreement of both parties the student may be allowed to undertake the title he suggested. At the end of 9 months the student submits a report and does a presentation, on which he is marked. While academic may be supervising a student, he/she might also be his/her tutor. An academic can be the tutor of one or more students but a student has only one tutor. A student can undertake only one project and a project is carried out by only one student. Similarly a student can undergo only one internship but a company can allow a maximum of three students to undergo internship. In the company the industrial supervisor can supervise a maximum of three students for their internship while the student is supervised by one industrial supervisor and an academic from SITE. (a) Produce an Entity Relationship Diagram (Logical Data Structure) for the above scenario. For each entity list the attributes and the respective primary key. (b) Translate your ERD into a relational database schema
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Enhanced ER Model
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS