Urgenthomework logo
UrgentHomeWork
Live chat

Loading..

7003Ict Data Management For Schema Assessment Answers

93 Download 📄 2 Pages / 344 Words
Describe the Data Management For Schema Refinement and Documentation.

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).

  1. There is no data redundancy in the tables.
  2. 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

Email

Programid

Programid àPROGRAMS(Programid )

Student number

Date of birth

Sex

Nationality

Home address

Date enrolled

Email

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

Email

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.


Get Online Support for 7003Ict Data Management For Schema Assessment Answers Assignment Help Online


Copyright © 2009-2023 UrgentHomework.com, All right reserved.