CSE2DCX - Database Fundamentals on the Cloud - IT/Computer Science Assignment Help

Assignment Task

Background 
For years ABC Car Rentals has depended on their manual information recording procedures  to store information about their customers, salesman and cars. The rental shop maintains  these different types of information in separate paper-based files. 
This manual procedure is quite difficult to handle and maintain, especially in the instances  where retrieval of data or a search for information is required. As you can imagine, retrieving  a required record from a massive file is both difficult and time consuming. Apart from these  problems storing many paper-based files requires significant storage space. 
To overcome these problems ABC Car Rentals has decided to take advantage of technology, to create an application that will allow them to perform these functions in a more efficient  manner. 
The rental shop has decided to handover the design of the database of this project to an  Information Technology customer, you! Below is a description of the data needed and how it  interrelates. You are expected to model this information via an ER / EER diagram and map it  to relations.  
The database will need to model information about three different individuals, customer,  salesman, and manager. These will have some common attributes such as, ID, first name,  last name, date of birth, phone, address 1, address 2, suburb, postcode, and type (which  can be “customer”, “salesman”, or “manager”). In addition to this general information 
passwords for salesman and managers should also be stored.  
The database should also store working hours for salesman and managers. The working  hours will be represented as shifts with each shift having one manager and multiple  salesman. It should be noted that each manager and salesman can be associated with  multiple shifts. Shift will include, shift ID, date, day, start and finish times. 
The database should also store customer’s payment information, this will include, Customer  name, card number, cvv number, expiry date, and type (visa, master, amex). 
Customers can apply for a rental transaction. The transaction has transaction id, customer  id, amount, duration, information about the car, pickup date, drop off date, pickup time, drop  off time, pickup location, drop off location, and salesman responsible for the transaction. It  should be noted that one salesman can be associated with many transactions while each  transaction can have only one salesman.  
Transactions have cars mapped to them. The car information comprises of the car ID, name,  brand, type (sedan, coupe, wagon, utility), year, and price. Note that a transaction can  consist of one or more cars while each car could be part of multiple transactions. 
Tasks 
The assessment consists of two tasks, which are as follows, 
Task 1 
Draw an ER/EER diagram for the above-mentioned database in Microsoft Visio using Crow’s Foot Database Notation. 
For each entity:
1. Give the entity an appropriate name. 
2. Include all attributes. Be aware that not all primary keys and/or foreign keys may have  been explicitly mentioned in the problem statement above. It is your job to add these  as necessary for a correct solution. 
3. Annotate the primary key attribute(s) as . 
4. Annotate the foreign key attribute(s) as . 
For each relationship: 
5. Annotate the cardinality at each end as “zero or more”, “one or more”, “one and only  one”, or “zero or one” (“Database Systems”, Coronel and Morris, 2017, p. 132). 6. Use an arrow to represent any inheritance relationship(s). 
7. Add a label to each relationship. For example, if you wanted to model the relationship  between a Supplier and a Product in an inventory database, you could use the  annotation “provide” to say that suppliers “provide” products.  
Task 2 
In this task, you will create a relational model for the above-mentioned database. 
1. Map the above diagram from Task 1 to a relational model for all relations in Microsoft  Word. For example, for a product relation, Product(ProductID, ProductName, Price,  SupplierID), the primary key attribute(s) are in underline, the foreign key attribute(s)  are in italics, and both styles would need to be applied if an attribute is both primary  and foreign. 
2. You must also check that your solutions for Tasks 1 and 2 are compatible with each  other. Update your solution(s) as necessary. 

This CSE2DCX IT/Computer Science Assignment has been solved by our IT/Computer Science Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.