This article provides a list of entities and attributes for System Analysis and Design. It also includes an ER diagram and assumptions made during the process.
Contribute Materials
Your contribution can guide someone’s learning journey. Share your
documents today.
Running head: SYSTEM ANALYSIS AND DESIGN System Analysis and Design Name of the Student: Name of the University: Author Note
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
1 SYSTEM ANALYSIS AND DESIGN List of Entities and Attributes The identified list of entities is provided below: Staffs Addresses Customer Rentals Reservation Vehicle Vehicle Category The identified list of attributes for each of the entities are provided below: Staffs:StaffNumber,FName,LName,HomeAddress,Gender,DateOfBirth, OfficeNumber, OfficePhoneNumber Addresses: HomeAddress, StreetNumber, Suburd, Post-Code, City, State Customer:CustomerNumber,FirstName,LastName,HomeAddress,Gender, DateOfBirth, TelephoneNumber, DriverLicenseNumber Rentals: RentID, RegistrationNumber, CustomerNumber, Borrow_Date, Return_Date, TotalCost, StaffNumber, VehicleCondition Reservation:ReservationID,RegistrationNumber,CustomerNumber, ReservationPeriod, TotalCost, StaffNumber, VehicleCondition Vehicle:RegistrationNumber,CategoryName,Make,Model,Colour, Rental_Price/Day Vehicle Category: CategoryName, Rental_Charges, NumberOSeats After the identification of the list of entities and attributes the logical model can be created as defined below:
3 SYSTEM ANALYSIS AND DESIGN ER Diagram Figure 1: ER Diagram of NSW Car Rental System Source: (Created by Author) Assumptions and Justification of the ER Diagram For the creation of the ER Diagram provided above it is to be noted that majority of the information has been taken from the case study. However, some additional assumptions were required before the ER Diagram could be implemented for the formulation of a clear idea.
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
4 SYSTEM ANALYSIS AND DESIGN It is to be noted that the case study has defined the home addresses of the customers and the staffs of the organization as a single attribute but it is to be noted that the attribute is multi valued one and for denoting the multivalued an additional entity has been assumed and all the sub attributes of the main attribute has been added as the main attributes in the Home Address entity. In addition to this, it is to be noted that the Vehicles are identified by their unique registration number, however no information about the categorization of the vehicles has been provided and hence, it has been assumed that there would be some categories and hence an entity named vehicle category has been added to the Diagram. It has also been assumed that the Rentals of the organization would be identified by some unique fields and the filed is denoted by RentID in the rent entity.
5 SYSTEM ANALYSIS AND DESIGN Bibliography Bull, E.R., Dombrowski, S.U., McCleary, N. and Johnston, M., 2014. Are interventions for low-income groups effective in changing healthy eating, physical activity and smoking behaviours? A systematic review and meta-analysis.BMJ open,4(11), p.e006046. Elias-Miró, J., Grojean, C., Gupta, R.S. and Marzocca, D., 2014. Scaling and tuning of EW and Higgs observables.Journal of High Energy Physics,2014(5), p.19. Jung, T., Jo, H.L., Nam, S.H., Yoo, B., Cho, Y., Kim, J., Kim, H.M., Hyeon, T., Suh, Y.D., Lee, H. and Lee, K.T., 2015. The preferred upconversion pathway for the red emission of lanthanide-doped upconverting nanoparticles, NaYF 4: Yb 3+, Er 3+.Physical Chemistry Chemical Physics,17(20), pp.13201-13205. Kern, E.R. and Lardinois, S.M., International Business Machines Corp, 2014.Sharing computer data among computers. U.S. Patent 8,868,628.