The Entity Relationship Diagram ERD Computer Science Essay

In undertaking 1, I have to pull the Entity Relationship Diagram ( ERD ) for both the logical and physical to depict the content and the informations held by the section. When I analyzed the college information, I find that the section has the three chief capable countries to analyze which are databases, information systems and unreal intelligence.

The capable country leader leads each capable country. Anyone from the staff can be a capable country leader for merely one capable country. There are five undergraduate programmes offered by each capable country and each programme takes 3 old ages to analyze. There are four faculties per twelvemonth for each undergraduate programme. The programme leader leads each undergraduate programme. The capable country leader can besides be a programme leader at the same clip. Anyone from the staff can be a programme leader for a upper limit of three programmes. The faculty leader is in charge for each faculty. The pupils can go to in full clip manner or portion clip manner. The difference between full clip manner and portion clip manner is the figure of the faculties studied per twelvemonth.

The programme decision maker has all the information of all pupils who are registered to the programme including the personal inside informations, the programme rubric, the twelvemonth and the faculty registration. Student advancement is recorded harmonizing to the test and the coursework and the attending in the talks and the seminars and the research lab Sessionss. The test and the coursework are defined for each faculty. All faculties are mandatory and there are no optional faculties. The pupils may disrupt their programme for a defined period of clip by their personal instances. A pupil is awarded a base on balls for the faculty if the overall faculty grade is greater than 40 % . A pupil who passes the faculty is awarded 30 credits for that faculty and a pupil who fails the faculty is awarded nothing credits for that faculty.

We Will Write a Custom Essay Specifically
For You For Only $13.90/page!


order now

Premise

After I finished analysing, I draw the Entity Relationship Diagram ( ERD ) for both the logical and physical. I take out 16 entities from the analyzed papers. They are Capable Area, Programme, Module, Module Detail, Staff, Student, Exam, Exam Detail, Coursework, Coursework Detail, Lecture, Lecture Detail, Seminar, Seminar Detail, Laboratory and Laboratory Detail. There are five undergraduate programmes for each capable country and there is merely one capable country for each programmes. So I construct one to many relationship between Subject Area entity and Programme entity.

There is a batch of staff for each capable country and there is merely one capable country for each staff. So I construct one to many relationship between Subject Area entity and Staff entity. There is a batch of staff for each programme and there is merely one programme for each staff. So I construct one to many relationship between Programme entity and Staff entity. There is a batch of pupils for each programme and there is merely one programme for each pupil. So I construct one to many relationship between Programme entity and Student entity. There are 12 faculties for each programme and there is merely one programme for each faculty. So I construct one to many relationship between Programme entity and Module entity. There are a batch of staff for each faculty and there is merely one faculty for each staff. So I construct many to many relationship between Module entity and Staff entity. There are a batch of pupils for each faculty and there are besides a batch of faculties for each pupil. So I construct many to many relationship between Module entity and Student entity. Because of the relationship is many to many, I place the silent person tabular array named Module Detail between Student entity and Module entity.

There is one to many relationship between Module entity and Module detail entity and there is besides one to many relationship between Student entity and Module Detail entity. There are a batch of tests for each faculty and there is merely one faculty for each test and so I construct one to many relationship between Module entity and Exam entity. There are a batch of courseworks for each faculty and there is merely one faculty for each coursework and so I construct one to many relationship between Module entity and Coursework entity. There are a batch of pupils for each test and there is besides a batch of tests for each pupil. So I construct many to many relationship between Student entity and Exam entity. Because of the relationship is many to many, I place the silent person tabular array named Exam Detail between Student entity and Exam entity. There is one to many relationship between Student entity and Exam Detail entity and there is besides one to many relationship between Exam Detail entity and Exam entity. There are a batch of pupils for each coursework and there is besides a batch of courseworks for each pupil. So I construct many to many relationship between Student entity and Coursework entity. Because of the relationship is many to many, I place the silent person tabular array named Coursework Detail between Student entity and Coursework entity.

There is one to many relationship between Student entity and Coursework Detail entity and there is besides one to many relationship between Coursework entity and Coursework Detail entity. There are a batch of pupils for each talk and there are a batch of talks for each pupil. So, I construct many to many relationship between Lecture entity and Student entity. Because of the relationship is many to many, I place the silent person tabular array named Lecture Detail between Lecture entity and Student entity. There is one to many relationship between Student entity and Lecture Detail entity and there is besides one to many relationship between Lecture Detail and Lecture. There are a batch of seminars for each pupil and there are besides a batch of pupils for each seminar and so I construct many to many relationship between Student entity and Seminar entity. Because of the relationship is many to many, I place the silent person tabular array named Seminar Detail between Student entity and Seminar entity. There is one to many relationship between Student entity and Seminar Detail entity and there is besides one to many relationship between Seminar Detail entity and Seminar entity. There are a batch of research lab Sessionss for each pupil and there are besides a batch of pupils for each research lab Sessionss and so I construct many to many relationship between Student entity and Laboratory entity. Because of the relationship is many to many, I place the silent person tabular array named Laboratory Detail between Student entity and Laboratory entity. There is one to many relationship between Student entity and Laboratory Detail entity and there is besides one to many relationship between Laboratory Detail entity and Laboratory entity.

Undertaking 2

Analysis

In undertaking 2, I have to normalise the signifier and specify the primary keys and the foreign keys and specify the Fieldss and tabular arraies to build the database. I analyze the signifiers from the colledge and I normalize the information from them.

Premise

When I finished analysing the information, I normalize informations from four signifiers. They are Student Allocation Form, Exam Result Form, Coursework Result Form and Recording of Attendance Form. I take out six tabular arraies from the Student Allocation Form. They are Student tabular array, Subject Area tabular array, Programme tabular array, Module tabular array, Module Detail tabular array and Staff tabular array. The Fieldss for the Student tabular array are Student ID, Name, NRC, Sex, Father ‘s Name, Mother ‘s Name, Address, Phone Number, Attend Mode, Year, Start Date, End Date, Subject Area ID and Programme ID. The primary key for the pupil tabular array is Student ID and the foreign keys are Capable Area ID and Programme ID. The Fieldss for the Subject Area tabular array are Capable Area ID, Subject Area Name and Period. The primary key for the Subject Area tabular array is Capable Area ID and there is no foreign key for Subject Area ID. The Fieldss for the Programme tabular array are Programme ID, Programme Name, Fee, Start Date, End Date, Period and Subject Area ID. The primary key for the Programme tabular array is Programme ID and the foreign key is Capable Area ID. The Fieldss for the Module Detail tabular array are Student ID, Module ID and Result. The Module Detail tabular array has composite primary key, Student ID and Module ID and the foreign key is Student ID and Module ID.

The Module Detail tabular array is the silent person tabular array between Module tabular array and the Student tabular array. The Fieldss for the Module tabular array are Module ID, Module Name, Start Date, End Date, Period and Programme ID. The primary key for the Module tabular array is Module ID and the foreign key is Programme ID. The Fieldss for the Staff tabular array are Staff ID, Staff Name, Post, Address, Phone Number, Salary, Subject Area ID, Programme ID and Module ID. The primary key for the Staff tabular array is Staff ID and the foreign keys are Capable Area ID, Programme ID and Module ID. I take out two more tabular arraies from the Exam Result signifier. They are the Exam tabular array and the Exam Detail tabular array. The Fieldss for the Exam tabular array are Exam ID, Exam Title, Exam Date, Answering Time, Number of inquiries and Module ID. The primary key for the Exam tabular array is Exam ID and the foreign key is Module ID. The Fieldss for the Exam Detail tabular array are Exam ID, Student ID, Mark and Grade. The Exam Detail tabular array has the composite primary key, Exam ID and Student ID and the foreign keys are Exam ID and Student ID. The Exam Detail tabular array is the silent person tabular array between the Student tabular array and the Exam tabular array. I take out two more tabular arraies from the Coursework Result Form. They are the Coursework tabular array and the Coursework Detail tabular array. The Fieldss for the Coursework tabular array are Coursework ID, Coursework Title, Coursework Date, Number of Tasks, Allow Period and Module ID. The primary key for the Coursework tabular array is Coursework ID and the foreign key for the Coursework tabular array is Module ID. The Fieldss for the Coursework Detail tabular array are Corsework ID, Student ID, Mark and Grade. The Coursework Detail tabular array has the composite primary key, Coursework ID and Student ID. The foreign keys for the Coursework Detail tabular array are Student ID and Coursework ID. The Coursework Detail tabular array is the silent person tabular array between the Student tabular array and the Coursework tabular array. I take out another six tabular arraies form the Recording Of Attendance Form.

They are the Lecture tabular array, the Lecture Detail tabular array, the Seminar tabular array, the Seminar Detail tabular array, the Laboratory tabular array and the Laboratory Detail tabular array. The Fieldss for the Lecture tabular array are Lecture ID, Lecture Title and Date. The primary key for the Lecture tabular array is Lecture ID and there is no foreign key for the Lecture tabular array. The Fieldss for the Lecture Detail tabular array are Student ID, Lecture ID and Lecture ‘s Attendance. The Lecture Detail tabular array has the composite primary key, Student ID and Lecture ID. The foreign keys for the Lecture Detail tabular array are Student ID and Lecture ID. The Lecture Detail tabular array is the silent person tabular array between the Student tabular array and the Lecture tabular array. The Fieldss for the Seminar are Seminar ID, Seminar Title and Date. The primary key for the Seminar tabular array is Seminar ID and there is no foreign key for the Seminar tabular array. The Fieldss for the Seminar Detail tabular array are Student ID, Seminar ID and Seminar ‘s Attendance. The Seminar Detail tabular array has the composite primary key, Student ID and Seminar ID. The foreign keys for the Seminar Detail tabular array are Student ID and Seminar ID. The Seminar Detail tabular array is the silent person tabular array between the Seminar tabular array and the Student tabular array. The Fieldss for the Laboratory tabular array are Laboratory ID, Laboratory Title and Date. The primary key for the Laboratory tabular array is Laboratory ID and there is no foreign key for the Laboratory tabular array. The Fieldss for the Laboratory Detail tabular array are Student ID, Laboratory ID and Laboratory ‘s Attendance. The Laboratory Detail tabular array has the composite primary key, Student ID and Laboratory ID. The foreign keys for the Laboratory Detail tabular array are Student ID and Laboratory ID. The Laboratory Detail tabular array is the silent person tabular array between the Laboratory tabular array and the Student tabular array.

Undertaking 3

Analysis

In the undertaking 3, I have to put up all the normalized tabular arraies that are from the standardization that I make in the undertaking 2 by utilizing the Database Management System ( DBMS ) and I have to input some trial informations to the tabular arraies.

Premise

So, I use Microsoft Access 2003 DBMS to put up the tabular arraies. When I construct the Coursework tabular array, I define the Fieldss such as CourseworkID, CourseworkTitle, CourseworkDate, NoOfTasks, AllowPeriod and ModuleID. The format for the CourseworkID is text and it is used to hive away the coursework ID. The format of the CourseworkTitle is text and it is used to hive away the rubric of the coursework. The format of the CourseworkDate is date/time and it is used to hive away the day of the month of the coursework. The format of the NoOfTasks is figure and it is used to hive away the figure of undertakings for each coursework. The format of the AllowPeriod is text and it is used to hive away the allowed period to make the coursework.

The format of the Module ID is text and it is used to hive away the faculty ID. I give the primary key to the Coursework ID. When I construct the Coursework Detail tabular array, I define the Fieldss such as CourseworkID, StudentID, Mark and Grade. The format for the CourseworkID is text and it is used to hive away the coursework ID. The format for the StudentID is text and it is used to hive away the pupil ID. The format for the Mark is figure and it is used to hive away the grade that the pupil gets for each coursework. The format for the class is text and it is used to hive away the class that the pupil gets for each coursework. I give the composite primary key, Student ID and Coursework ID to the Coursework Detail tabular array. When I construct the Exam tabular array, I define the Fieldss such as ExamID, ExamTitle, ExamDate, AnsweringTime, NoOfQuestions and ModuleID. The format for the ExamID is text and it is used to hive away the test ID. The format for the ExamTitle is text and it is used to hive away the rubric of the test. The format for the ExamDate is date/time and it is used to hive away the day of the month of the test.

The format for the AnsweringTime is text and it is used to hive away the respondent clip of the test. The format for the NoOfQuestions is figure and it is used to hive away the figure of inquiries for each test. The format for the ModuleID is text and it is used to hive away the faculty ID. I give the primary key to the Exam ID. When I construct Exam Detail tabular array, I define the Fieldss such as ExamID, StudentID, Mark and Grade. The format for the ExamID is text and it is used to hive away the test ID. The format for the StudentID is text and it is used to hive away the pupil ID. The format for the Mark is figure and it is used to hive away the grade that the pupil gets for each test. The format for the Grade is text and it is used to hive away the class that the pupil gets for each test. I give the composite primary key, ExamID and StudentID to the Exam Detail tabular array.

When I construct Laboratory tabular array, I define the Fieldss such as LaboratoryID, LaboratoryTitle and Date. The format for the LaboratoryID is text and it is used to hive away the research lab ID. The format for the LaboratoryTitle is text and it is used to hive away the rubric of the research lab. The format for the Date is date/time and it is used to hive away the day of the month of the research lab session. I give the primary key to the LaboratoryID. When I construct Laboratory Detail tabular array, I define the Fieldss such as StudentID, LaboratoryID and Laboratory’sAttendance. The format for the Student ID is text and it is used to hive away the pupil ID. The format for the LaboratoryID is text and it is used to hive away the research lab ID. The format for the Laboratory’sAttendance is text and it is used to hive away the attending of the pupil for each research lab session. I give the composite primary key, StudentID and LaboratoryID to the Laboratory Detail tabular array. When I construct Lecture tabular array, I define the Fieldss such as LectureID, LectureTitle and Date. The format for the LectureID is text and it is used to hive away the talk ID. The format for the LectureTitle is text and it is used to hive away the rubric of the talk. The format for the Date is date/time and it is used to hive away the day of the month of the talk. I give the primary key to the LectureID. When I construct Lecture Detail tabular array, I define the Fieldss such as StudentID, LectureID and Lecuture’sAttendance. The format for the StudentID is text and it is used to hive away the pupil ID.

The format for the LectureID is text and it is used to hive away the talk ID. The format for the Lecture’sAttendance is text and it is used to hive away the attending of the pupil for each talk. I give the composite primary key, StudentID and LectureID to the Lecture Detail tabular array. When I construct Module tabular array, I define the Fieldss such as ModuleID, ModuleName, StartDate, EndDate, Period and ProgrammeID. The format for the ModuleID is text and it is used to hive away the faculty ID. The format for the ModuleName is text and it is used to hive away the name of the faculty. The format for the StartDate is date/time and it is used to hive away the start day of the month of the faculty. The format for the EndDate is date/time and it is used to hive away the terminal day of the month of the faculty. The format for the Period is text and it is used to hive away the period of the faculty. The format for the ProgrammeID is text and it is used to hive away the Programme ID. I give the primary key to the ModuleID. When I construct Module Detail tabular array, I define the Fieldss such as StudentID, ModuleID and Result. The format for the StudentID is text and it is used to hive away the pupil ID. The format for the ModuleID is text and it is used to hive away the faculty ID. The format for the Result is text and it is used to hive away the consequence of the pupil for each faculty. I give the composite primary key, ModuleID and StudentID. When I construct Programme tabular array, I define the Fieldss such as ProgrammeID, ProgrammeName, Fee, StartDate, EndDate, Period and SubjectAreaID. The format for the ProgrammeID is text and it is used to hive away the programme ID.

The format for the ProgrammeName is text and it is used to hive away the name of the programme. The format for the Fee is figure and it is used to hive away the fee for the programme. The format for the StartDate is date/time and it is used to hive away the start day of the month of the programme. The format for the EndDate is date/time and it is used to hive away the terminal day of the month of the programme. The format for the Period is text and it is used to hive away the period of the programme. The format for the SubjectAreaID is text and it is used to hive away the capable country ID. I give the primary key to the ProgrammeID. When I construct the Seminar tabular array, I define the Fieldss such as SeminarID, SeminarTitle and Date. The format for the SeminarID is text and it is used to hive away the Seminar ID. The format for the SeminarTitle is text and it is used to hive away the rubric of the rubric of the seminar. The format for the Date is date/time and it is used to hive away the day of the month of the seminar. I give the primary key to the Seminar ID. When I construct SeminarDetail tabular array, I define the Fieldss such as StudentID, SeminarID and Seminar’sAttendance.

The format for the StudentID is text and it is used to hive away the pupil ID. The format for the SeminarID is text and it is used to hive away the seminar ID. The format for the Seminar’sAttendance is text and it is used to hive away the attending of the pupil for each seminar. I give the composite primary key, StudentID and SeminarID to the Seminar Detail tabular array. When I construct the Staff tabular array, I define the Fieldss such as StaffID, StaffName, Post, Address, PhoneNo, Salary, SubjectAreaID, ProgrammeID and ModuleID. The format for the StaffID is text and it is used to hive away the staff ID. The format for the StaffName is text and it is used to hive away the name of the staff. The format of the Post is text and it is used to hive away the station of the staff. The format of the Address is text and it is used to hive away the reference of the staff. The format of the PhoneNo is text and it is used to hive away the phone figure of the staff. The format of the Salary is figure and it is used to hive away the wage of the staff. The format of the SubjectAreaID is text and it is used to hive away the capable country ID.

The format for the ProgrammeID is text and it is used to hive away the programme ID. The format for the ModuleID is text and it is used to hive away the faculty DI. I give the primary key to the StaffID. When I construct the Student tabular array, I define the Fieldss such as StudentID, Name, NRC, Sex, Father’sName, Mother’sName, Address, PhoneNo, AttendMode, Year, StartDate, EndDate, SubjectAreaID and ProgrammeID. The format for the StudentID is text and it is used to hive away the pupil ID. The format for the Name is text and it is used to hive away the name of the pupil. The format for the NRC is text and it is used to hive away the NRC of the pupil. The format for the Sex is text and it is used to hive away the sex of the pupil. The format for the Father’sName is text and it is used to hive away the male parent ‘s name of the pupil. The format for the Mother’sName is text and it is used to hive away the female parent ‘s name of the pupil. The format for the Address is text and it is used to hive away the reference of the pupil. The format of the PhoneNo is text and it is used to hive away the phone figure of the pupil. The format of the AttendMode is text and it is used to hive away the attend manner whether the pupil is portion clip pupil or full clip pupil. The format of the Year is figure and it is used to hive away the twelvemonth of the pupil. The format of the StartDate is date/time and it is used to hive away the start day of the month of the pupil. The format of the EndDate is date/time and it is used to hive away the terminal day of the month of the pupil. The format of the SubjectAreaID is text and it is used to hive away the capable country ID. The format of the ProgrammeID is text and it is used to hive away the programme ID. I give the primary key to the StudentID. When I construct the Subject Area tabular array, I define the Fieldss such as SubjectAreaID, SubjectAreaName and Period. The format for the SubjectAreaID is text and it is used to hive away the capable country ID. The format for the SubjectAreaName is text and it is used to hive away the name of the capable country. The format for the Period is text and it is used to hive away the period of the capable country. I give the primary key to the SubjectAreaID.

Undertaking 4

Analysis

In undertaking 4, I have to I have to put up and prove the questions by utilizing the Structured Query Language ( SQL ) . In inquiry 1, I have to put up the question to expose all the capable country leaders, programme leaders and faculty leaders along with the names of the capable countries, programmes or faculties they lead. In inquiry 2, I have to put up the questions to expose the list of programmes under the Artificial Intelligence capable country and I have to expose the list of faculties under these programmes and besides the list of pupils who win the Pass for one of the faculties. In inquiry 3, I have to put up the question to expose the pupil ‘s twelvemonth of survey, the faculty they study and their test and coursework Markss and test for these faculties.

Premise

So I create SQL statements by utilizing Microsoft Access Database 2003. In inquiry 1, I take out staff name and station from staff tabular array, capable country name from the capable country tabular array and the faculty name from the faculty tabular array. In inquiry 2 ( a ) , I take out programme name from programme tabular array where the capable country is Artificial Intelligence. In inquiry 2 ( B ) , I take out the faculty name from the faculty tabular array where the faculties are under the programmes of the Artificial Intelligence capable country. In inquiry 2 ( degree Celsius ) , I take out the pupil name, consequence from the pupil tabular array and the faculty item tabular array merely the consequence is base on balls. In inquiry 3, I take out pupil name, twelvemonth, faculty name, exam ID, exam grade, coursework ID and coursework grade from the pupil tabular array, faculty tabular array, test tabular array, exam item tabular array, coursework tabular array and coursework item tabular array.

Books

Database Design and Development

Systems Design