logo

Database Modeling Assignment

34 Pages4782 Words129 Views
   

Added on  2020-07-23

Database Modeling Assignment

   Added on 2020-07-23

ShareRelated Documents
Database ModelingFor University of Newlyfoundland
Database Modeling Assignment_1
IntroductionTypically the university information system is developed as the integrated system, hoping to computerize all university operations. Processes use general college registers, general classifications. The idea allows for individual users avoiding the different interpretation of the same records. All data are held in a centralized database. This kind of way it allows the steering clear of of data duplication. Information is definitely gathered, put to the database and managed, where the first methods are placed, i. e. inside the university subdivisions.That’s the reason why the circulation time regarding documents decreases, less reason mistakes are made, and seek and elimination of errors can be done effectively.Entity Name:DEPARTMENT, COURSE, MODULES, STUDENTS, FACULTY, QUALIFICATIONS, TEACHINGNormalization: Database Normalization is a technique of organizing the data in the database. Normalization is a systematic approach of decomposing tables to eliminate data redundancy and undesirable characteristics like Insertion, Update and Deletion Anomalies. It is a multi-step process that puts data into tabular form by removing duplicated data from the relation tables.Normalization is used for mainly two purposes,Eliminating redundant (useless) data.Ensuring data dependencies make sense i.e data is logically stored.Normalization rule are divided into following normal form.First Normal FormSecond Normal FormThird Normal FormBCNF
Database Modeling Assignment_2
1NF:UIS (dept_id, dept_name, dept_primary_location, dept_address, dept_secondary_address, dept_email, dept_phone, dept_fax, coursename, duration, credit_hours, modulename,title, credit_hours, level,first_name, middle,_name, last_name, stud_street,, stud_city, stud_zip, stud_home_address, stud_email, stud_phone, date_of_birth, next_of_kin_name, ext_of_kin_address, next_of_kin_relationship, next_of_kin_phone, stud_region faclt_name, faclt_home_address, faclt_office_location, faclt_room_number, faclt_fax. Faclt_email,faclt_home_phone, faclt_mobile, data_of_birth, gender,next_of_kin_name, next_of_kin_address, next_of_kin_relationship, next_of_kin_phone, date_joined, salary,quali_desciption)2NF:Departments (dept_name, dept_primary_location, dept_address, dept_secondary_address, dept_email, dept_phone, dept_fax, coursename, duration, credit_hours, modulename,title, credit_hours, level, courseid, faclt_id )Students (stud_id, first_name, middle,_name, last_name, stud_street,, stud_city, stud_zip, stud_home_address, stud_email, stud_phone,Date_of_birth, next_of_kin_name, next_of_kin_address, next_of_kin_relationship, next_of_kin_phone, stud_region, courseid, faclt_id )Faculty (faclt_id, faclt_name, faclt_home_address, faclt_office_location, faclt_room_number, faclt_fax. Faclt_email,faclt_home_phone, faclt_mobile, data_of_birth, gender,next_of_kin_name, next_of_kin_address, next_of_kin_relationship, next_of_kin_phone, date_joined, salary,quali_desciption, description, hours_a_week, faclt_id )
Database Modeling Assignment_3
3NF:Departments (dept_id, dept_name, dept_primary_location, dept_address, dept_secondary_address, dept_email, dept_phone, dept_fax, faclt_id )Courses (courseid, coursename, duration, credit_hours, dept_id, faclt_id)Modules (moduleid,modulename,title, credit_hours, level, courseid, faclt_id )Students (stud_id, first_name, middle,_name, last_name, stud_street,, stud_city, stud_zip, stud_home_address, stud_email, stud_phone,Date_of_birth, next_of_kin_name, next_of_kin_address, next_of_kin_relationship, next_of_kin_phone, stud_region, courseid, faclt_id )Faculty (faclt_id, faclt_name, faclt_home_address, faclt_office_location, faclt_room_number, faclt_fax. Faclt_email,faclt_home_phone, faclt_mobile, data_of_birth, gender,next_of_kin_name, next_of_kin_address, next_of_kin_relationship, next_of_kin_phone, date_joined, salary, quali_id )Qualifications(quali_id, quali_desciption)Teaching (teachingid, description, hours_a_week, faclt_id )
Database Modeling Assignment_4
Entity Relationship Diagram
Database Modeling Assignment_5
Data dictionaryTable Name : DEPARTMENTSField NameData TypeSizePrimary Key OrForeign keyCommentsDEPT_IDNumber10Primary KeyDEPT_NAMEVarchar2100DEPT_PRIMARY_LOCATIONVarchar2100DEPT_ADDRESSVarchar2150DEPT_SECONDARY_ADDRESSVarchar2100DEPT_EMAILVarchar250DEPT_PHONEVarchar250DEPT_FAXVarchar250FACLT_IDNumber10Foreign keyTable Name : COURSESField NameData TypeSizePrimary Key OrForeign keyCommentsCOURSEIDNumber10Primary KeyCOURSENAMEVarchar2100DURATIONNumber10CREDIT_HOURSNumber10DEPT_IDNumber10Foreign keyFACLT_IDNumber10Foreign keyTable Name : MODULESField NameData TypeSizePrimary Key OrForeign keyCommentsMODULEIDNumber10Primary KeyMODULENAMEVarchar2100TITLEVarchar2120CREDIT_HOURSNumber10LEVELNumber2COURSEIDNumber10Foreign keyFACLT_IDNumber10Foreign keyTable Name : TEACHING
Database Modeling Assignment_6
Field NameData TypeSizePrimary Key OrForeign keyCommentsTEACHINGIDNumber10Primary KeyDESCRIPTIONVarchar2100HOURS_A_WEEKNumber10FACLT_IDNumber10Foreign keyTable Name : QUALIFICATIONSField NameData TypeSizePrimary Key OrForeign keyCommentsQUALI_IDNumber10Primary KeyQUALI_DESCIPTIONVarchar2150Table Name : FACULTYField NameData TypeSizePrimary Key OrForeign keyCommentsFACLT_IDNumber10Primary KeyFACLT_NAMEVarchar2100FACLT_HOME_ADDRESSVarchar2100FACLT_OFFICE_LOCATIONVarchar2100FACLT_ROOM_NUMBERNumber10FACLT_FAXVarchar250FACLT_EMAILVarchar250FACLT_HOME_PHONEVarchar250FACLT_MOBILEVarchar250GENDERchar1DATE_OF_BIRTHDateNEXT_OF_KIN_NAMEVarchar2100NEXT_OF_KIN_ADDRESSVarchar2100NEXT_OF_KIN_RELATIONSHIPVarchar2100NEXT_OF_KIN_PHONEVarchar250DATE_JOINEDDateSALARYNumber12,2QUALI_IDNumber10Foreign key
Database Modeling Assignment_7
Table Name : STUDENTSField NameData TypeSizePrimary Key OrForeign keyCommentsSTUD_IDNumber10Primary KeyFIRST_NAMEVarchar2100MIDDLE_NAMEVarchar2100LAST_NAMEVarchar2100STUD_STREETVarchar250STUD_CITYVarchar250STUD_ZIPVarchar250STUD_HOME_ADDRESSVarchar2100GENDERChar1FACLT_IDNumber10Foreign keySTUD_EMAILVarchar250STUD_PHONEVarchar250DATE_OF_BIRTHDateNEXT_OF_KIN_NAMEVarchar2100NEXT_OF_KIN_ADDRESSVarchar2100NEXT_OF_KIN_RELATIONSHIPVarchar2100NEXT_OF_KIN_PHONEVarchar250STUD_REGIONVarchar210COURSEIDNumber10Foreign keyImplementationTable creation
Database Modeling Assignment_8

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Database design ER diagram Normalization - DOC
|34
|6065
|240

KC7013 DATABASE MODELLING | SQL
|26
|3569
|10

IT 354 - Advanced Web Application Development
|10
|1016
|116

Database of Business Rules Entities and Attributes
|20
|2546
|433