Facebook Pixel Code
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

Systems analysis / database design exercise Essay Example

Show related essays

Systems analysis / database design exercise

This is a preview of the 9-page document
Read full text

To achieve the first normal form the primary key focus is changed in order to discriminate repeated groups. For example for the following un-normalized entity the focus is on the Dept# as a primary key.To achieve second normal form full functional dependencies are to be observed. Attributes that are not fully dependant are isolated as another entity with the respective primary key. For example for the above mentioned entity,While there are significant non key attributes that are fully dependent on “Department” entity, therefore to achieve second normal form a new entity namely department is introduced with its respective primary key and dependent attributes.The two entities namely Student and Course are linked to each other in a many – many relationship.0 highlights the respective relationship. A student can take multiple courses while a course can be taken by multiple students. However it is possible that a course is not opted by any student. On the other side a student must opt for at least a course to maintain the status of a student.The process of registration explains the link between these two entities to a greater extent.1 highlights that a student gets registered with a course and a course is offered to students for registration.Similarly the relationship between section and courses exists in the same manner. Multiple courses are taught in a section while a course may be taught in multiple sections. The respective elaborated ER diagram is presented in Figure 2.The relationship of students with their department and their section are of same type i. one – many. A department or a section may have multiple students but a student may get associated with a single section or department at a time. However for a section to exist at least one student is required to study into it while there is no such restriction for the existence of a department. The relationship between Student and Grade Report will always be one – one. In general there will always be one grade report for each student but this case is a bit tricky. If the grades are recorded course wise or semester wise the there may exist multiple records against the id of each student. This is done in order to allow gradual updates. The fact is that whenever a student’s marks report is queried there will be just one up to date consolidated report.3 highlights the E – R model.The entities “Instructor” and “Section” are linked in a many – many

This is a preview of the 9-page document
Open full text
Close ✕
Tracy Smith Editor&Proofreader
Expert in: Systems Science, Astronomy, Other
Hire an Editor
Matt Hamilton Writer
Expert in: Systems Science, Anthropology, Biology
Hire a Writer
preview essay on Systems analysis / database design exercise
WE CAN HELP TO FIND AN ESSAYDidn't find an essay?

Please type your essay title, choose your document type, enter your email and we send you essay samples

Contact Us