Database assignment 2 Example | Topics and Well Written Essays - 2500 words

Database 2 - Assignment ExampleIt is a car rental company based in the USA. As a car hire organization, cipher Car Hire Company requires various systems to parcel out its operations. The company has branches all over the world and reserve can be made directly via branched or online through the companys website and cistron websites. Three Proposed Applications In this report, three proposed applications that fulfill the companies needs will be discussed. Specifically, the three applications are to drive transactions and operations. The applications are Direct Renting from braches. Online participation system. Car purchasing system. The systems will hit to be integrated into a single database and network for the purpose of data access and processing. This is the function of the data modelling process. Brief overview of the Applications Direct contract from braches This application describes the transaction where the client goes directly to the companies branches and asks for a car to rent. Depending on the availability of car, the customer has to provide staff with his licenses, bank card number and personal information such(prenominal) as realise, age and address. A customer must also buy an insurance package alone then, a member of staff will enter the information n the system and give bear an invoice along with the car keys. Online booking system The online booking system is an application that will modify customers to do car reservation online through compute website. The online booking should be able to process the booking and produce the corresponding confirmation message or travel vouchers to the applicant. The customer must fill a form on Budgets website that provides the company with his/her information like name, age, address and other personal and paying information. close to importantly, the type of car, pick up and return time and ensure, location. The website calculates the price for the selected vehicle for the specified period. Aft er that, customers prevail an email confirmation. Car purchasing system The third application is for car purchasing, where employees in the logistics department Budget gets to interact with different car vendors. The Budget employee has to select the car type, color, model, price and quantity. After that the application generates the name of the buyer (Budget), seller (vendor), purchasing date and time and the total price of the transaction including the cars specifications, quantity and date of manufacture. Key Data Required for Each Application The systems require various data items because they all manage different data and processes. Each database will have various datasets. Of course, some of the data sets will have common data fields shared between themselves (Heath and Bizer 36). The databases for each application will have local model with entity relationships specifically between the entities in them. Overall, the local models will be linked into a large model, the globa l data model. The global data model will link the three databases in such a way that the three applications have relationships with each other through the relationships in their entities. Direct renting from braches Direct renting from braches application will have the following data entities Entity Attribute RENTAL RENTAL_NO primary quill Key (PK), CUST_ID foreign key (FK), RENTAL_TIME, RENTAL_DATE, PICKUP_DATE, RETURN_DATE, PICKUP_TIME, RETURN_TIME, CAR_ID (FK), PRICE_PAID,