IT Solutions

2070 words 9 pages
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
…show more content…
I would like to conduct an interview regarding Easy Drive car rental system to model the data objects.
Admin Staff: Good Afternoon, it’s my pleasure to help you.
WIC Representative: How would you like to describe Easy Drive daily routine?
Admin Staff: Basically our daily routine is to record customer booking information and assign the booking to the car that we have. It is crucial for us to have timely and accurate information about our customer booking and number of cars that are available. We would like to record customer personal information, customer booking information, car information, and information of our staff.
WIC Representative: What information you would like to capture regarding your customer personal information?
Admin Staff: We would like to capture our customer name, address, and their phone number.
WIC Representative: What about car and staff information?
Admin Staff: We would like to capture our car type, colour, seating, capacity, availability and rent price. For staff, we would like to capture our staff name, address, phone number, salary, working hours, and rate per hour.
WIC Representative: Is there any specific information you would like to capture regarding customer booking besides booking start date and end date?
Admin Staff: No, we only need to know the booking start and end date.
WIC Representative: That is all for my interview. Thank you for your time.
Admin Staff: It’s my pleasure to help you.

Related

  • Hw1 Solution
    1339 words | 6 pages
  • Problem Solution Homelessness
    1123 words | 5 pages
  • Solution for the Decline of Circulation of Newspaper
    1064 words | 5 pages
  • Refining Solutions Paper
    1040 words | 5 pages
  • Estimating Glucose Concentration in Solution
    2099 words | 9 pages
  • Corporate Fiance Assignment Solution
    2243 words | 9 pages
  • Solution
    1587 words | 7 pages
  • Appendix E Solution
    3544 words | 15 pages
  • Security Assessment - Aircraft Solutions
    1355 words | 6 pages
  • Problem Solution Essay
    1634 words | 7 pages