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

CP5639 Conceptual Modelling For Attributes And Different Relationships

tag 0 Download5 Pages / 1,047 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT
  • Course Code: CP5639
  • University: James Cook University
  • Country: Australia

Question:

Write a one or two sentence description of what your function will do. Describe any inputs and outputs.

 

 

 

Answer:

Discussion

This report discusses the solution for the conceptual modelling of the Joanne Myers Apartments. Conceptual modelling involves following a few steps in order to achieve the final conceptual model for the database. The first step is thoroughly studying the case study to get information on all the entities and their attributes and different relationships that exist between the entities. After identifying the entities, the next step is to define the business rules to come up with the types of relationships that exist between different entities. After identifying the entities, relationships and the type of relationships an entity relationship can be drawn. To draw the entity relationship diagram, Microsoft Visio 2013 is used. The entity relationship shows all the entities and their respective relationships. Primary keys and foreign keys are clearly in the ERD. The last step is providing a justification and explanation for the relationships achieved in the ERD. The justifications should be aligned with the case study and for cases where the case study is not clear, the assumptions are stated.

While performing the task some problems rose that limited the final conceptual design from being absolutely perfect. This problem experienced while drawing the diagrams using Microsoft Visio. Arranging the diagrams so that the relationships do not overlap was lot of work as it involved doing a lot of rearrangements to make sure all the relationships are flowing fine without overlapping.

Business rules

Based on the case study, the following are the business rules derived;

Entity: COMPLEX

Each complex has one or more APARTMENT

Each complex is managed by one LESSEES.

The manager of a complex must a tenant in the complex.

Entity: APARTMENT

Each APARTMENT belongs to only one COMPLEX

Each APARTMENT can have only one LEASE at a time

Each APARTMENT is allocated one or more PARTKING_LOT

Each APARTMENT have one or more MAINTENANCE_JOB

Each APARTMENT has one or more PREINSTALLED_EQUIPMENT

Entity: PREISNTALLED_EQUIPMENT

Each PREINSTALLED_EQUIMENT is allocated to only one APARTMENT

Entity: PARKING_LOT

Each PARKING_LOT is associated with only one APARTMENT

Each PARKING_LOT belongs to only one building COMPLEX.

Entity: LEASE

Each LEASE has one or more LESSEE

Each LEASE is signed by a maximum of 5 LESSEE.

Each LEASE is associated with only one APARTMENT

Entity: LESSEE

Each LESSEE is involved in only one LEASE

Each LESSEE rents only one APARTMENT

Each LESSEE makes one or more RENT_PAYMENTS

Each LESSEE is allocated one or more KEYS

Each LESSEE can make none or many RENTALS

Entity: MAITENANCE_COMPANY

Each MAINTENANCE_COMPANY can be associated with none or many MAINTENANCE_JOBS

Entity: MAINTENANCE_JOB

Each MAINTENANC_JOB is associated with only one APARTMENT

Each MAINTEANCE_JOB is done by only one MAINTENANCE_COMPANY

Entity: KEY

Each KEY results to one or more KEY_ALLOCATION records

Entity: RENTAL_EQUIPMENT

Each RENTAL_EQUIPMENT is associated with none or many RENTAL

Entity: RENTAL

Each RENTAL is associated with one and only RENTAL_EQUIPMENT

Entity: RENT PAYMENT

Each RENT_PAYMENT is done by one and only one LESSEE

Each RENT_PAYMENT is for a LEASE

Entity: LOCKUP_GARAGE

Each LOCKUP_GARAGE is associated with one and only APARTMENT  

 

Summary

The following are the justifications explaining why the database design ended up as shown in the entity relationship diagram shown above;

  • The relationship between entity BUILDING and APARTMENT is one to many mandatory because a building has one or more apartments. No building has no apartments and that is why the relationship is mandatory.
  • The relationship between entity APARTMENT and PARKING_LOT is one to many mandatory because every apartment is allocated one or more parking slots. There is no apartment without a parking lot but some apartments are allocated more than one parking slot.
  • The relationship between entity APARTMENT and LOCKUP_GARAGE is one to one optional because not all apartments are allocated a lockup garage. Only some selected apartments are allocated lock-up garages.
  • The relationship between entity APARTMENT and EQUIPMENT is one to many mandatory because an apartment is allocated one or more equipment.
  • The relationship between entity LEASE and APARTMENT is one to one mandatory because an a lease is created for one and only one apartment and that is why the relationship is one to one mandatory.
  • The relationship between LEASE and LESEE is one to many mandatory because a lease has one or more lessees. A lease cannot exist at least one lessee thus its mandatory for a lease to have at least one lessee. A lease can have a maximum of 5 lessees.
  • The relationship between APARTMENT and MAINTENANCE_JOB one to many optional because an apartment none or many maintenance jobs.
  • The relationship between MAINTEANCE_JOB and MAINTENANCE_COMPANY is one to one mandatory because a maintenance job is done by one and only one maintenance company.
  • The relationship between the LESSEE and KEY_ALLOCATIONS is one to many mandatory because a lessee is allocated to one or more keys.
  • The relationship between KEY and KEY_ALLOCATIONS is one to one mandatory because a key is allocated only once for every key allocation record created.
  • The relationship between LESSEE and RENT_PAYMENT is one to many mandatory because a LESSEE pays makes one or more rent payments while staying in an apartment.
  • The relationship between LESEE and rentals is one to many optional because a LESEE can make none or many rentals for rental equipment as it not a must for a lessee to rent a rental equipment.
  • The relationship between a RENTAL_EQUIPMENT and RENTALS is one to many optional because an equipment can be rented be none or many times. A rental equipment may exist and not rented even once. 
 

While modelling the database, a special case of data integrity that cannot be handled was realized. This case of data integrity is for entity KEY specifically opens attribute. The opens attribute is saves what the key opens for example if the key opens apartment 1 then the opens attribute is supposed to have apartment 1 as the data. To identify the apartment that a key opens there should exist a relationship between the key attribute and the apartment attribute. However, this is not possible because not all keys open a specific apartment. Some key open different places like the gym.

Download Sample

Get 100% money back after download, simply upload your unique content* of similar no. of pages or more. We verify your content and once successfully verified 100% value credited to your wallet within 7 days.

Upload Unique Document

Document Under Evaluation

Get Credits into Your Wallet

*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:

My Assignment Help. (2020). Conceptual Modelling For Attributes And Different Relationships. Retrieved from https://myassignmenthelp.com/free-samples/cp5639-conceptual-modelling-for-attributes-and-different-relationships.

"Conceptual Modelling For Attributes And Different Relationships." My Assignment Help, 2020, https://myassignmenthelp.com/free-samples/cp5639-conceptual-modelling-for-attributes-and-different-relationships.

My Assignment Help (2020) Conceptual Modelling For Attributes And Different Relationships [Online]. Available from: https://myassignmenthelp.com/free-samples/cp5639-conceptual-modelling-for-attributes-and-different-relationships
[Accessed 07 August 2020].

My Assignment Help. 'Conceptual Modelling For Attributes And Different Relationships' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/cp5639-conceptual-modelling-for-attributes-and-different-relationships> accessed 07 August 2020.

My Assignment Help. Conceptual Modelling For Attributes And Different Relationships [Internet]. My Assignment Help. 2020 [cited 07 August 2020]. Available from: https://myassignmenthelp.com/free-samples/cp5639-conceptual-modelling-for-attributes-and-different-relationships.


Getting nightmare regarding pending chemistry assignment? Then it is high time you consider hiring chemistry assignment help service of MyAssigemnthelp.com. We at MyAssignmenthelp.com deliver quality subject specific assistance on more than 100+ subjects. For us, students' need is foremost, and we work round the clock to offer science, humanities and commerce assignment help. Among Commerce wing, our one of the most popular services is capital budgeting assignment help. In science segment, we have gained popularity with biology assignment help.

Latest Management Samples

HAT202 The Hospitality And Tourism Market 2

Download : 0 | Pages : 5
  • Course Code: HAT202
  • University: Kaplan Business School
  • Country: United States

Answer: Introduction The objective of the report is to analyse the information about the business portfolio of the Hungry Jack’s fast food organization. The company is an Australian franchise of Burger King Company that is operating in Australia from 1971. Food and beverages industry of the tourism and hospitality segment is chosen to analyse the innovation trends present in the environment.  The business portfolio of Hungry Jack&r...

Read More arrow Tags: Australia Vale Park 9 Hospitality Other 

BUS110 Workplace Learning 1

Download : 0 | Pages : 15
  • Course Code: BUS110
  • University: Charles Sturt University
  • Country: Australia

Answer: Introduction  The job market comprises of group of people who are looking for jobs within the current economy. It comprises of a variety of jobs that the employers are willing to the offer and the employees are ready to accept. For instance the Australian Job market has a strong future because of the increasing number of people who are ready to work (Challis et al., 2018). There is an expected growth in the Australian job market ...

Read More arrow Tags: Australia Melbourne 28 workplace learning 1 Other 

MKT340 International Management 2

Download : 0 | Pages : 20
  • Course Code: MKT340
  • University: Charles Sturt University
  • Country: Australia

Answer: Introduction The business which is operating at an international level needs to possess knowledge about international management. This knowledge is important for the organization to grow as well as to expand globally. This management requires the skill set and knowledge beyond normal business knowledge (Morschett, Schramm-Klein & Zentes, 2015). The company needs to be familiar with the regulations set for the business in the co...

Read More arrow Tags: Australia Burwood 9 International Management Other 

BUS510 Organisational Learning And Change 3

Download : 0 | Pages : 2

Answer: Personal Reflection of Senge’s Book, “The Fifth Discipline” These chapters have been interesting to read through since they give vivid explanation and examples on why some business fail while other succeed. The author explains the concepts of organization learning in an interesting manner that is intriguing for the reader. Use of real life examples makes one to relate with what is happening currently in various organ...

Read More arrow Tags: Australia Arlington Management University of New South Wales 

ACC203 Financial Accounting 2

Download : 0 | Pages : 5
  • Course Code: ACC203
  • University: Kaplan University
  • Country: United States

Answer: Introduction The information in the email regarding the accoutring issues sent to me on 13 November 2017 is acknowledged by Magenta and Associates. In response to the email relevant amendments and advice is been drafted in the letter, which could be useful for the board of Beachlife Ltd in making adequate decision. Furthermore, the amendments and advice provided by the accounting team is reliable, as it is backed by years of experienc...

Read More arrow
Next
watch

Save Time & improve Grade

Just share Requriment and get customize Solution.

question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

1,379,740

Orders

4.9/5

Overall Rating

5,085

Experts

Our Amazing Features

delivery

On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.

work

Plagiarism Free Work

Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.

time

24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat.

subject

Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.

price

Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

Our Experts

Assignment writing guide
student rating student rating student rating student rating student rating 5/5

1692 Order Completed

98% Response Time

Alfred Dodd

PhD in Computer and Information Science with specialization in Database

Wellington, New Zealand

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

93 Order Completed

100% Response Time

Jackson Mitchell

MiM (Masters in Management) in Supply Chain Management

New Jersey, United States

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

453 Order Completed

98% Response Time

Howard Asuncion

LLM in Criminal Law

London, United Kingdom

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

529 Order Completed

95% Response Time

Ivan Blank

PhD in Functional Human Biology

Wellington, New Zealand

Hire Me

FREE Tools

plagiarism

Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.

essay

Essay Typer

Get different kinds of essays typed in minutes with clicks.

edit

GPA Calculator

Calculate your semester grades and cumulative GPa with our GPA Calculator.

referencing

Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.

calculator

Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

Refer Just 5 Friends to Earn More than $2000

Check your estimated earning as per your ability

1

1

1

Your Approx Earning

Live Review

Our Mission Client Satisfaction

Awesome work. Awesome response time. Very thorough & clear. Love the results I get with MAH!

flag

User Id: 383727 - 31 Jul 2020

Australia

student rating student rating student rating student rating student rating

Work was done in a timely manner took it through grammarly checked for plagiarism very well satisfied

flag

User Id: 463334 - 31 Jul 2020

Australia

student rating student rating student rating student rating student rating

Great work for the short notice given. Thank you for never disappointing and helping out.

flag

User Id: 194216 - 31 Jul 2020

Australia

student rating student rating student rating student rating student rating

I received a full point on the assignment. Thank you for all the help with the assignment.

flag

User Id: 411395 - 31 Jul 2020

Australia

student rating student rating student rating student rating student rating
callback request mobile
Have any Query?