ICT200 Database Design and Development Assignment

Assignment Help Database Management System
Reference no: EM132551586

ICT200 Database Design and Development Assignment - King's Own Institute, Australia

Case Study -

National Strata provides strata management service for properties in Sydney. It provides cleaning, plumbing, electrical, gardening, other general repair and maintenance services for many properties. Depending on the contract, one or more services are provided at every property. In case property comprises of townhouses and units, each owner is a client. However, every client within a property is provided same services as per the contract. Contract must be renewed every year for every client.

To manage all these properties, national strata uses many rented office spaces in the proximity of properties they serve across Sydney where staff members work from. For each property, a strata manager is designated. One strata manager can work on many properties, but each property can have only one manager. Apart from strata manager, they have other admin, accounting, cleaning, electrical, plumbing, handy men in repair and maintenance team.

National strata has a fleet of rental vehicles which staff members can use to attend to service calls. However, some staff members prefer to use their own vehicles. Staff members using company vehicle is assigned the vehicle. Staff members usually get a list of calls they must attend to every day. One or more staff members may attend to one or more service calls.

National strata maintain a shift roster and strata manager consults roster to assign staff members to attend calls. A staff member can be assigned to work on only one shift per day but each shift will have multiple staff members.

The company needs to organize meetings for its clients, for this they must maintain a list of clients along with their names, property details, contact details. They must also collect payments from clients for services provided on a quarterly basis. A list of defaulters is maintained so penalties may be applied as per the by-laws. Company also needs to maintain a list of expenses they incur for each property so accounts can be audited quarterly.

Task 1 - ER Diagram

Identify the entities, relationships, participation and cardinality from the above case study. Use UPPERCASE to name your entities and use Capitalisation (of first letter) to name attributes of entities. Underline all primary key attributes and mention all the foreign key attributes. Specify relationship verb.

Resolve many to many relationships.

State your assumptions clearly.

Create an ER diagram using crow's foot notation in any tool of your choice. Hand drawn diagrams will not be accepted.

Task 2 - Normalization

List all the dependencies in a dependency diagram including partial and transitive.

Show the determinants and select primary key, foreign key.

Starting with unnormalized data, convert all the tables to 1 NF. Clearly outline the rules for a table to be in 1 NF and provide justification.

Identify partial dependency if any and resolve it.

Identify transitive dependency if any and resolve it.

Make sure the tables are in BCNF. Explain the rule with tables as example.

Identify multivalued dependency if any and resolve it.

At each stage list the rules and provide explanation of why the tables are in 2, 3 or 4 NF.

Video Presentation -

Write a personal reflection on the task highlighting the key takeaways from the tasks and any challenges you might have faced. Record a 5-minute video with your face clearly visible explaining both the tasks you performed above. Upload it on youtube as an unclassified video and share the link in the document after writing personal reflection word limit 250 words.

Reference no: EM132551586

Questions Cloud

Explain the risk to the organisation of not applying : Explain the risk to the organisation of not applying the National Employment Standards in Australia.
Describe a relevant policy or practice in your organization : Describe a relevant policy or practice in your organization that may influence your selected healthcare issue/stressor. Critique the policy for ethical.
Why an impairment loss needs to be recognised in relation : Provide the appropriate journal entry at 30 June 2022 to account for the impairment. why an impairment loss needs to be recognised in relation
What are the pharmacological treatments for depression : In the third scenario of the simulation, Eugene is recovering from surgery: Answer these questions based on the scenario given: What are the pharmacological.
ICT200 Database Design and Development Assignment : ICT200 Database Design and Development Assignment Help and Solution - King's Own Institute, KOI, Australia - Assessment Writing Service
Discuss benefits of virtualization software : Discuss the benefits of virtualization software, as described in the text. Do you agree/disagree with these benefits, or can you think of additional benefits
What decision would you make if you were in george situation : The practice of health care providers at all levels brings you into contact with people from a variety of faiths. This calls for knowledge and understanding.
Find and identify the type of each adjusting entry : Four types of adjusting entries are described at the beginning of the chapter. Using these descriptions, identify the type of each adjusting entry.
Describe proposed erm solution to resolve proposed risks : Describe the proposed ERM solution to resolve the proposed risks based on ERM popular models. Be sure to include timelines, resources, visualizations, etc.

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd