IT Solutions

Topics: Database normalization, Data modeling, Entity-relationship model Pages: 9 (2079 words) Published: October 10, 2014
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
Customer can search, select, check availability and purchase a book Book ID
ISBN Number
Book Title
Book Author
Book Genre
Executive summary of the book
Book Available Quantity
Book Price
Customer Information
Customer
Staff

5. Case Study – Pizza Supreme

Context diagram

Develop a level 0 data flow diagram from the context diagram. The level 0 data flow diagram must show the same data flows form and to the external entities as appear on the context diagram.

Develop a level 1 data flow diagram for any of the processes you have identified in the level 0 data flow diagram.

Develop a Data Dictionary for a data flow‐ “Pizza order = pizza quantity + pizza size + pizza type + pizza price + pizza total” by using the template below.

Type
Length
Description
Example
Pizza Quantity
Variable
4
Number of Pizza ordered
25
Pizza Size
Variable
2
Size of the Pizza
17 (inch)
Pizza Type
Character
20
Type of the pizza
Vegetarian
Pizza Price
Currency
3
Individual price of the pizza
$ 25
Pizza Total
Currency
7
Total price for the order
$2,350
Driver’s Name
Character
25
Driver’s name
Mark Thomson
Counter Staff Name
Character
25
Counter Staff name
Lena Watson

6. Use case diagram for Student Enrolments:

Consider the above use case diagram and write a narrative description (or scenario) for the “Student Full‐fee Enrolment” use case by using below template.

Use Case Name
Student Full-Fee Enrolment
Description
A student interacts with enrolment staff to enrol in a course.  Enrolment staff will then generate a student invoice. Actors
Student
Enrolment staff
Precondition
Enrolment staff must have logged into the system successfully Activities
A student initiates an enrolment with enrolment staff
Student indicates which course he/she wishes to enrol in
Enrolment staff check course availability
If the required course is unavailable, students can choose another...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Solutions Dilutions Essay
  • Essay on Spectrophotometric Analysis of Kmno4 Solution
  • Essay on Synergetic Solutions Report
  • Essay about Saline solution lab
  • Concentration, Solution, Density Essay
  • Determining Concentration of a solution Lab Essay
  • Solution Suspension And Colloids Research Paper
  • Osmolarity: Concentration and Sucrose Solutions Essay

Become a StudyMode Member

Sign Up - It's Free