IGNOU MCS 23 2010 2011 - For creating a student information management system of a Un

Question

For creating a student information management system of a University a database management system is better than that of file management system.” Justify the statement given above. Now, assume that you are assigned the role of database administrator for the University database. What are the key responsibilities you have to handle?

28 Oct 2017

Answer :

Word Count : 249

For creating a student information management system of a University by the normalization.

Image ignouacademy-com--p-ignou-71972

A second normal form if every relation scheme include in the database scheme is in second normal form.

UNIVERSITY (Uni_name, Uni_id, Uni_add)

STUDENT (S_roll no., S_name, S_address, sex)

CLASSROOM (capacity, Room no., Location)

EXAM (Exam_subs, Date of exam)

EXA-CENTRE (address, phone no.)

EMPLOYEE (ssn, e.sex, e_salary, e_name, e_add)

Entities and their attributes refer the full information of student in a University. Database management system is better than file management system because the database system contains not

_____ _____ ________ _______ ___ ___ ____.
__________ _____ ____ _____ ________ ______.
_________ _______ ___ __________ __________ ________ ____ ________ _______.
__________ _________ __________ ________ ___ ______.
___ ___ ________ _________ _____.
______ _____ ___ ____ ________ ____ _____ ____ _____ _________.
_________ ________ _________ ________ _____ ___ _____ ___ _______ _________.
__________ _________ ____ _____ ________ ____ _________ ____.
_________ ____ _______ __________ _________ ___ ____ _______ __________ _________.
_______ _____ __________ _____ _______ _____ ___ _________.
____ ________ ______ ______ _______ ________ _____ ______ ____.
________ __________ __________ _______ ___ _____ ____ _____ __________ _______ _____ ____.
_____ __________ _______ ___ _______.
___ ___ ___ ___ ______ _________ ______ __________ _____ _______ ________ ____.
________ ___ _______ _______ ______ ___ ___ _________ ________.
_____ ___ ___ _________ ____ _____.
___ ____ _______ _____ _____ _____ _________ ____.
_____ _______ ______ ____ ___ ______ _________ __________.
_________ __________ _______ __________ _______ __________ _________ _______.
______.

IGNOU ACADEMY

Your IGNOU journey, made easier.

Solved Assignments
Study Notes
Guess Papers
Question Papers

Call Us WhatsApp

STUDY • PREPARE • SUCCEED

Skip in 10

IGNOU Solved Assignments Assignments Ignou Projects Project Previous Year Solved Exam Papers Notes Notes Sample Question Papers Sample Question Papers