preview

IT Solutions Essay

Better Essays

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…

Case study: Easy Drive Easy Drive is a car rental company that offers the best car hire prices in Australia. The company is located in Sydney, Melbourne, and Brisbane. Easy Drive branches could be found at all major airports and in downtown locations. In addition, online car reservation system is also provided for the ease of the booking experience. Easy Drive is not only providing affordable prices, but also providing the best car rental experience. The company is well known for its excellent customer service. Moreover, Easy Drive has more than 12,000 vehicles that range from car, van, and busses. The company’s goal is to keep increasing their service offering but partnering with various service providers. Due to the growth and expansion of the company, Easy Drive currently is in deep need of renewing its database system. Easy Drive has trusted WIC to model its data objects and to provide the company with a documentation of its business data model. It is vital for easy drive to have an accurate and reliable data, across all of its business processes in order to provide an excellent car rental experience to its customers. Thus, a detail list of business data and normalisation procedure is required to model the company’s data. Interview

Get Access