IT Solutions
1. Identify suitable business data, data elements, data types, and resources, based on the following interview between a database analyst and a lecturer from Sutherland University:
Business Data
Data Elements
Data Types
Resources
Course
Course code
Course name
Course start date
Course end date
Integer
Character
Date
Date
Admin
Classes
Class name
Start date
End date
Time
Location
Class capacity
Integer
Date
Date
Date time
Integer
Variable
Admin
Students
Student ID
Student name
Grade
Integer
Character
Variable
Admin
2.
a. Describe the characteristic of second normal form in a normalization process
A relation is said to be in Second Normal Form (2NF) if and only if it is already in first normal form and all non key attributes are dependent on the whole key. That is all partial dependencies are removed.
b. Conduct a second normalisation procedure for the following data
Student ID
Class ID
Class Name
Class Location
100001
0021
Algebra 101
Wentworth Lecture Room 2
100002
0264
Organic Chemistry
Holmes building Room 312
100003
2816
Software development1
Webster Theatre A
100004
0264
Organic Chemistry
Holmes building Room 312
The dependencies suggest 2 tables.
Class Details Table
Class ID
Class Name
Class Location
0021
Algebra 101
Wentworth Lecture Room 2
0264
Organic Chemistry
Holmes building Room 312
2816
Software development1
Webster Theatre A
0264
Organic Chemistry
Holmes building Room 312
Class table
Student ID
Class ID
100001
0021
100002
0264
100003
2816
100004
0264
3. Business Rules
One customer can only book one photographer per session
One photographer is assigned to only one customer per session
Many photo sessions can running together at one time
Customers are required to pay a $ 100 deposit to secure the appointment
4. Level O Data Flow Diagram of an online book purchasing system
Functional Requirement Information Needs
Users Group
Business Data
Data Elements
Data Types
Resources
Course
Course code
Course name
Course start date
Course end date
Integer
Character
Date
Date
Admin
Classes
Class name
Start date
End date
Time
Location
Class capacity
Integer
Date
Date
Date time
Integer
Variable
Admin
Students
Student ID
Student name
Grade
Integer
Character
Variable
Admin
2.
a. Describe the characteristic of second normal form in a normalization process
A relation is said to be in Second Normal Form (2NF) if and only if it is already in first normal form and all non key attributes are dependent on the whole key. That is all partial dependencies are removed.
b. Conduct a second normalisation procedure for the following data
Student ID
Class ID
Class Name
Class Location
100001
0021
Algebra 101
Wentworth Lecture Room 2
100002
0264
Organic Chemistry
Holmes building Room 312
100003
2816
Software development1
Webster Theatre A
100004
0264
Organic Chemistry
Holmes building Room 312
The dependencies suggest 2 tables.
Class Details Table
Class ID
Class Name
Class Location
0021
Algebra 101
Wentworth Lecture Room 2
0264
Organic Chemistry
Holmes building Room 312
2816
Software development1
Webster Theatre A
0264
Organic Chemistry
Holmes building Room 312
Class table
Student ID
Class ID
100001
0021
100002
0264
100003
2816
100004
0264
3. Business Rules
One customer can only book one photographer per session
One photographer is assigned to only one customer per session
Many photo sessions can running together at one time
Customers are required to pay a $ 100 deposit to secure the appointment
4. Level O Data Flow Diagram of an online book purchasing system
Functional Requirement Information Needs
Users Group