7003Ict Data Management For Schema Assessment Answers
Answer:
Section I
Conceptual design
Logical design
Schema refinement and documentation
In the above entity relation diagram all the tables are in 3-NF and they are related to each other without any duplication or data redundancy this is due to the following reasons (Ullman, 2016).
- There is no data redundancy in the tables.
- There are no anomalies like the insertions, update and deletions (Bipin, 2014).
- All tables have the data integrity.
|
Table name |
Attributes |
Description |
Type |
Constraint |
Comment |
|
SCHOOL
FKS: |
Schoolid Schoolname Officelocation Telephonenumber Faxnumber Headstaffid Deputystaffid Adminofficerstaffid Headstartdate Adminstartdate HeadstaffidàSTAFFS(Headstaffid) Deputystaffidà STAFFS(Headstaffid) Adminofficerstaffidà STAFFS(Headstaffid) |
School id School name Office locations Telephone number Fax number Head Deputy Admin officer Head start date Admin start date |
int(10) varchar(200) varchar(200) varchar(200) int(20) int(10) int(10) int(10) date date |
Primary key Foreign key Foreign key Foreign key |
unique |
|
STAFFS |
Staffid Fullname DOB Sex Postaladdress Level Position Expertise |
Staff identity Full names Date of birth Sex Postal address Level Position Expertise |
int(10) varchar(200) date varchar(200) varchar(200) varchar(200) varchar(200) varchar(200) |
Primary key |
unique |
|
OFFICE FKS: |
Officeid Roomid Phonenumber Building Staffid StaffedàSTAFFS(staffid) |
Office identity Room identity Phone number Building name Staff identity |
int(10) int(10) int(20) varchar(200) int(10) |
Primary key Foreign key |
unique |
|
COURSE FKS: |
Courseid Classid Classtype Weekday Time Length Roomno Buidingno Staffid StaffedàSTAFFS(staffid) |
Course identity Class identity Class type Weekday Time Length Room number Buiding number Staff identity |
int(10) int(10) varchar(200) varchar(200) datetime int(10) int(10) int(10) int(10) |
Primary key Foreign key |
unique |
|
ACADEMIC PROGRAM FKS: |
Programid Programname Director Courses Courseid Coursetype Creditpoints CourseidàCOURSE(Courseid) |
Program identity Program name Director name Courses Course identity Course type Credit points |
int(10) varchar(200) varchar(200) varchar(200) int(10) varchar(200) varchar(200) |
Primary key Foreign key |
unique |
|
STUDENTS FKS: |
Studentno DOB Sex Nationality Homeaddress Dateenrolled Programid Programid àPROGRAMS(Programid ) |
Student number Date of birth Sex Nationality Home address Date enrolled Program identity |
int(10) date varchar(200) varchar(200) varchar(200) date varchar(200) int(10) |
Primary key Foreign key |
unique |
|
NEXTOFKIN FKS: |
Nextofkinid Name Phone Address Relationship Studentno StudentnoàSTUDENTS(Studentno) |
Next of kin id Names Phone number Address number Email address Relationship Student number |
int(10) varchar(200) int(10) varchar(200) varchar(200) varchar(200) int(10) |
Primary key Foreign key |
unique |
(Abraham, 2013).
Reference
Abraham, S.(2013). Database System Concepts .Michigan: McGraw-Hill.
Bipin, D.(2014). An Introduction to Database Systems.Boston:Addison-Wessley Publication.
Raghu ,R.(2015). Database Management Systems. New York:McGraw-Hill Higher Education
Ullman,D.(2016). Principles of Database Systems. Berlin:Springer publishers;
Buy 7003Ict Data Management For Schema Assessment Answers Online
Talk to our expert to get the help with 7003Ict Data Management For Schema Assessment Answers to complete your assessment on time and boost your grades now
The main aim/motive of the management assignment help services is to get connect with a greater number of students, and effectively help, and support them in getting completing their assignments the students also get find this a wonderful opportunity where they could effectively learn more about their topics, as the experts also have the best team members with them in which all the members effectively support each other to get complete their diploma assignments. They complete the assessments of the students in an appropriate manner and deliver them back to the students before the due date of the assignment so that the students could timely submit this, and can score higher marks. The experts of the assignment help services at urgenthomework.com are so much skilled, capable, talented, and experienced in their field of programming homework help writing assignments, so, for this, they can effectively write the best economics assignment help services.
