fb
$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
Add File

Error goes here

COIT20247 Database Design And Development

tag 0 Download6 Pages / 1,359 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

Question:

In this assignment, you are going to perform the entity-relationship data modelling based on the following application scenario
From time to time, the clients may feel unsatisfactory on a service job done and therefore they may complain about service quality, expensive cost and other possible problems. If so, the lodged complaint should be recorded and processed appropriately by an admin staff, with a response addressed the outcome of investigation. Finally, AAS also wishes to maintain contact details for each client who requests service, including their residential address, contact phone, email and whether they are a senior citizen, who may receive some discount in a service.
 
You are required to develop an ER model to represent the information requirements for the application scenario (AAS) as described on last page.

Your ER model must: 
•    show all necessary entities, attributes and relationships 
•    show unique identifiers 
•    show multi-valued attributes (also called repeating attributes), if any 
•    show participation and cardinality 
•    show associative entities, if appropriate 
•    use the notation described in the set text 
•    use consistent and appropriate naming for entities and attributes throughout 

Some business rules or other aspects of the case study may not be clear to you when you read the case study. If this is the case, then you should either approach your lecturer or tutor for clarification, or you may simply make an assumption and then develop your ER model accordingly. For example, the case study might not mention all relevant participation information (also called minimum cardinalities). If so, you may make an assumption about what the minimum cardinalities might reasonably be, and then show these in your ER model accordingly. You should justify each assumption in terms of the business, for example: it is assumed that each customer must have at least one order because it is assumed that the business does not record customer details until the customer places an order. 

To get yourself started, ask yourself, 'If I were running this business, what things I would need to keep a list of?' Write those things down. For each thing, what information would you need to record about it? 

Entity and attribute definitions 

You are required to write brief definitions for the entities and attributes in your model. For each entity and attribute in your model, write a sentence to describe the meaning of that entity or attribute. You should refer to the sections Naming and Defining Entity Types and Naming and Defining Attributes in the textbook. 
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.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 6 pages, 1 USD Per Page

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2021). Database Design And Development. Retrieved from https://myassignmenthelp.com/free-samples/coit20247-database-design-and-development/associative-details.html.

My Assignment Help (2021) Database Design And Development [Online]. Available from: https://myassignmenthelp.com/free-samples/coit20247-database-design-and-development/associative-details.html
[Accessed 23 October 2021].

My Assignment Help. 'Database Design And Development' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/coit20247-database-design-and-development/associative-details.html> accessed 23 October 2021.

My Assignment Help. Database Design And Development [Internet]. My Assignment Help. 2021 [cited 23 October 2021]. Available from: https://myassignmenthelp.com/free-samples/coit20247-database-design-and-development/associative-details.html.


Students are often on the lookout for a top-notch academic website that can relieve them of their academic concerns. We, at MyAssignmenthelp.com, have got everything covered for you. After completing an assignment successfully, students often search for reliable reword tools, online word count tools, etc. The inability to find a reliable one can lead them to be accused of the severe crime of plagiarism. Our word count tools, paraphrase tools, etc., helps you scan your document thoroughly, and get the desired results. Our essay editors also manually revise each content, check the word count, and edit all the glaring errors to maintain the flawlessness of your assignment remarkably. Get in touch with us today!

Latest Management Samples

MGMT20144 Management And Business Context

Download : 0 | Pages : 10

Answer: Introduction: The concept of knowledge management (KM) has been augmented concerning the data management, knowledge and information within the organization along with employing for gaining competitive advantage. Knowledge Management basically encompasses the tools and process to effectively hypnotize and allocate data. In the present scenario where competition is in the rise, Knowledge Management and the connected strategies have beco...

Read More arrow Tags: Australia Melbourne Management Melbourne Institute of Technology 

PROJ6003 Project Execution And Control

Download : 0 | Pages : 11

Answers: Topic- Important factor of global project management:- Module 1 From the first module I have learned about changed management is considered to be important factor of project management. I have learned about the fact that various process or strategies which are essential for managing the various changes of project. In this module various topics like project team acquisition and development, direction and management of project wor...

Read More arrow

SM0380 Doing Business Globally And Internationally

Download : 0 | Pages : 14

Answers: Title: Analysis of the joint venture between Pfizer Inc. and Zhejiang Hisun pharmaceuticals 1. First off we start by analyzing the deal using Michael E. Porter’s model, the reasons for the joint venture and the involvement of the U.S. and Chinese governments in the deal. Competitive Rivalry In this segment we look at the competition in the Active Pharmaceutical Ingredients (API) manufacturing industry. Notably, in china ...

Read More arrow

XICT01 Information And Communication Technology

Download : 0 | Pages : 5

Answer: Introduction In this assignment we have analysed the data on migrant labourers. Migrant labourers form a large part of the labour force. The labour force has different levels of education. They work in different businesses. There is also a difference in businesses organization. According to research done by Näre (2015) there is a significant relationship between gender and migrant workers. Similarly, according to research done by...

Read More arrow Tags: Australia Haverfordwest Management business event management University of New South Wales 

BFA522 Risk Management

Download : 0 | Pages : 2

Answer: Introduction: Companies are likely to have engaged in various sustainable approaches that are more likely to establish the stakeholders for long term agreement. In the view point of Courtney et al. (1997), the risk management practices are no longer adequate to deal with the threats that the companies are facing in the recent time. Factors like intense competition, huge dependency on fossil fuel and others pose a new level of threat t...

Read More arrow Tags: Australia Glenelg Management Cross Culture Management University of Sydney Masters in Business Administration 
Next

5% Cashback

On APP - grab it while it lasts!

Download app now

*Offer eligible for first 3 orders ordered through app!

ribbon
callback request mobile
Have any Query?