Free Samples
COIT20247 Database Design And Development
.cms-body-content table{width:100%!important;} #subhidecontent{ position: relative;
overflow-x: auto;
width: 100%;}
COIT20247 Database Design And Development
0 Download2 Pages / 437 Words
Course Code: COIT20247
University: Central Queensland University
MyAssignmentHelp.com is not sponsored or endorsed by this college or university
Country: Australia
Question:
In this assignment, you need to create an Entity Relationship (ER) diagram relevant to the above case study and optionally perform logical design to produce appropriate 3NF Relations.
The attributes for various entities have not been purposely described in the case study so that the students are encouraged to further research and list the pertinent attributes in addition to the required identifier for each and every entity in their ERD.
1 Draw an appropriate ER diagram
Use the symbols as prescribed in your unit-textbook to draw the ER diagram (ERD) for the above case study.
Your ERD must
show all necessary entities, attributes and relationships
show identifiers/identifying attributes as necessary
show multi-valued attributes, if any
show participation and cardinality
show associative entities, if appropriate
show weak entities, if any
use the notation described in the set text
1 Identified entities (including super type and sub type entities), associative entities, weak entities (if any) and named appropriately
2 Provided appropriate attributes
3 Provided identifiers/identifying attributes
4 Drawn correct relationships between entities and named them appropriately
5 Used proper symbols for
entities including super type and sub type; associative entities; weak entities if any
relationships
identifying attributes
min and max cardinalities for the relationships
Answer:
Assumptions and Business rules
The following assumptions are made for the development of the ER Diagram.
The customers have all the necessary document and the licence that is required for booking the car from the QR Rental system.
It is also assumed that more than one employee is assigned to a car for the management of the service and delivery of the car to the customer who have booked the car for rental.
It is assumed that the database administrator would add the details of the customer and the employee accurately in the database table for the management of the errors in the database.
It is assumed that each of the car is insured with an insurance policy and the information system is used for recording the details of the insurance for reducing the effort of management.
The business rules identified for the development of the information system are listed below:
Categorizing the cars into different segments such as SUV, Sedan, Luxury limos, etc. and the location of the parking of the car should be recorded into the information system for increasing the security of the cars.
The cost of hiring the cars should also be recorded for the calculation of the rental cost.
The processing time of each of the request of the customer or the employee using the system should be minimum and the database tables should be connected with each other using the foreign key such that the accurate result of the query can be generated.
All the details of the cars, employees and the customers should be recorded in the database such that it can be used by the organization to improve the current business process.
References
Arasu, A., Babcock, B., Babu, S., Cieslewicz, J., Datar, M., Ito, K., Motwani, R., Srivastava, U. and Widom, J., 2016. Stream: The stanford data stream management system. In Data Stream Management (pp. 317-336). Springer Berlin Heidelberg.
Bhatt, S., Manadhata, P.K. and Zomlot, L., 2014. The operational role of security information and event management systems. IEEE Security & Privacy, 12(5), pp.35-41.
Buede, D.M. and Miller, W.D., 2016. The engineering design of systems: models and methods. John Wiley & Sons.
Dabbagh, M. and Lee, S.P., 2014. An approach for integrating the prioritization of functional and nonfunctional requirements. The Scientific World Journal, 2014.
Dennis, A., Wixom, B.H. and Tegarden, D., 2015. Systems analysis and design: An object-oriented approach with UML. John Wiley & Sons.
Di Sarno, C., Garofalo, A., Matteucci, I. and Vallini, M., 2016. A novel security information and event management system for enhancing cyber security in a hydroelectric dam. International Journal of Critical Infrastructure Protection, 13, pp.39-51.
Free Membership to World’s Largest Sample Bank
To View this & another 50000+ free samples. Please put
your valid email id.
Yes, alert me for offers and important updates
Submit
Download Sample Now
Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.
UploadUnique Document
DocumentUnder Evaluation
Get Moneyinto Your Wallet
Total 2 pages
PAY 2 USD TO DOWNLOAD
*The content must not be available online or in our existing Database to qualify as
unique.
Cite This Work
To export a reference to this article please select a referencing stye below:
APA
MLA
Harvard
OSCOLA
Vancouver
My Assignment Help. (2021). Database Design And Development. Retrieved from https://myassignmenthelp.com/free-samples/coit20247-database-design-and-development/prioritization-of-functional-and-nonfunctional.html.
“Database Design And Development.” My Assignment Help, 2021, https://myassignmenthelp.com/free-samples/coit20247-database-design-and-development/prioritization-of-functional-and-nonfunctional.html.
My Assignment Help (2021) Database Design And Development [Online]. Available from: https://myassignmenthelp.com/free-samples/coit20247-database-design-and-development/prioritization-of-functional-and-nonfunctional.html[Accessed 18 December 2021].
My Assignment Help. ‘Database Design And Development’ (My Assignment Help, 2021)
My Assignment Help. Database Design And Development [Internet]. My Assignment Help. 2021 [cited 18 December 2021]. Available from: https://myassignmenthelp.com/free-samples/coit20247-database-design-and-development/prioritization-of-functional-and-nonfunctional.html.
×
.close{position: absolute;right: 5px;z-index: 999;opacity: 1;color: #ff8b00;}
×
Thank you for your interest
The respective sample has been mail to your register email id
×
CONGRATS!
$20 Credited
successfully in your wallet.
* $5 to be used on order value more than $50. Valid for
only 1
month.
Account created successfully!
We have sent login details on your registered email.
User:
Password:
Are you unable to crack the code? Get quality assistance at MyAssignmenthelp.com to secure high grades in programming assignments. Our qualified experts provide programming help in Python, C, C++, Java etc. Java help and other object-oriented programming issues are solved by our experts at the best possible price. If you are in need of proofreading to check for the accuracy of the codes, you just need to place your order on our site. Our experts also help prepare computer lab reports by writing out the entire program with the outputs.
Latest Management Samples
div#loaddata .card img {max-width: 100%;
}
MPM755 Building Success In Commerce
Download :
0 | Pages :
9
Course Code: MPM755
University: Deakin University
MyAssignmentHelp.com is not sponsored or endorsed by this college or university
Country: Australia
Answers:
Introduction
The process of developing a successful business entity requires a multidimensional analysis of several factors that relate to the internal and external environment in commerce. The areas covered in this current unit are essential in transforming the business perspective regarding the key commerce factors such as ethics, technology, culture, entrepreneurship, leadership, culture, and globalization (Nzelibe, 1996; Barza, 2…
Read
More
SNM660 Evidence Based Practice
Download :
0 | Pages :
8
Course Code: SNM660
University: The University Of Sheffield
MyAssignmentHelp.com is not sponsored or endorsed by this college or university
Country: United Kingdom
Answers:
Critical reflection on the objective, design, methodology and outcome of the research undertaken Assessment-I
Smoking and tobacco addiction is one of the few among the most basic general restorative issues, particularly to developed nations such as the UK. It has been represented that among all risk segments smoking is the fourth driving purpose behind infections and other several ailments like asthma, breathing and problems in the l…
Read
More
Tags:
Australia Maidstone Management Business management with marketing University of New South Wales Masters in Business Administration
BSBHRM513 Manage Workforce Planning
Download :
0 | Pages :
20
Course Code: BSBHRM513
University: Tafe NSW
MyAssignmentHelp.com is not sponsored or endorsed by this college or university
Country: Australia
Answer:
Task 1
1.0 Data on staff turnover and demographics
That includes the staffing information of JKL industries for the fiscal year of 2014-15, it can be said that the company is having problems related to employee turnover. For the role of Senior Manager in Sydney, the organization needs 4 managers; however, one manager is exiting. It will make one empty position which might hurt the decision making process. On the other hand, In Brisba…
Read
More
MKT2031 Issues In Small Business And Entrepreneurship
Download :
0 | Pages :
5
Course Code: MKT2031
University: University Of Northampton
MyAssignmentHelp.com is not sponsored or endorsed by this college or university
Country: United Kingdom
Answer:
Entrepreneurial ventures
Entrepreneurship is the capacity and willingness to develop, manage, and put in order operations of any business venture with an intention to make profits despite the risks that may be involved in such venture. Small and large businesses have a vital role to play in the overall performance of the economy. It is, therefore, necessary to consider the difference between entrepreneurial ventures, individual, and c…
Read
More
Tags:
Turkey Istanbul Management University of Employee Masters in Business Administration
MN506 System Management
Download :
0 | Pages :
7
Course Code: MN506
University: Melbourne Institute Of Technology
MyAssignmentHelp.com is not sponsored or endorsed by this college or university
Country: Australia
Answer:
Introduction
An operating system (OS) is defined as a system software that is installed in the systems for the management of the hardware along with the other software resources. Every computer system and mobile device requires an operating system for functioning and execution of operations. There is a great use of mobile devices such as tablets and Smartphones that has increased. One of the widely used and implemented operating syste…
Read
More
Tags:
Australia Cheltenham Computer Science Litigation and Dispute Management University of New South Wales Information Technology
Next