User Account

All Pages

Create an ERD that represents your 3NF relations

Assignment Help Database Management System
Reference no: EM132314042

Assignment Task - Using given table

1. Draw a dependency diagram to show the functional dependencies in the relation.

2. Decompose the relation into a set of 3NF relations.

3. Draw a relational schema for your 3NF relations and show the referential integrity constraints.

4. Create an ERD that represents your 3NF relations.

Meeting ID

Meeting Date

Meeting Time

Meeting Venue

Event ID

User ID

Rating

Person ID

Status

1

24/1/2018

11:40 am

Library

1

IA

3

KC

Yes




1

DD

4

YA

No




1

KC

2

DD

Yes

2

25/1/2018

10:30 am

Trail St

2

IA

5

IA

Yes




2

DD

4

AK

Yes




2

KC

2





2

AK

3

3

26/1/2018

9:00 am

Blessed Bean

3

DD

3





3

IA

2

NOTE - For guidance on how to normalise database relations from a dependency diagram, watch this very short YouTube video: How to normalise database relations in 3 quick steps?

Manually drawing the dependency diagram, or the set of 3NF relations or the relational schema is NOT acceptable.

Rationale - This assessment task will assess the following learning outcome/s: be able to apply normalisation techniques to optimise a database design.

Attachment:- Assignment File.rar

Reference no: EM132314042

Questions Cloud

Compare and contrast the top accounting software packages : Compare and contrast the top five accounting software packages in Canada on the criteria - which package you would use in a small delivery business
Brief description of the notation used in the model : HS2011 Systems Analysis and Design Assignment, Holmes Institute, Australia. Brief description of the notation used in the model
Implement a custom environment for your maze game : Understand the distinction between software engineering and programming, and thus the distinction between a software configuration and a program
Interpret the relevant taxation legislations and case law : Interpret the relevant taxation legislations - concepts of income and deductions, CGT, FBT, GST general anti-avoidance provisions and income tax administration
Create an ERD that represents your 3NF relations : Draw a dependency diagram to show the functional dependencies in the relation. Create an ERD that represents your 3NF relations
Explain and justify the results of a statistical analysis : Statistics and Research Methods for Business Decision Making - Explain and justify the results of a statistical analysis in the context of critical reasoning
Explain decision criteria for rejecting null hypothesis : Describe 8 steps in process for hypothesis testing. Explain decision criteria for rejecting null hypothesis for both p-value method and critical value method.
Organization operate as socially responsible organization : Examine the manner in which your company's Supplier Code of Conduct helps the organization operate as a socially responsible organization.
Write a financial settlement system for a smartcard : 31253 - Database Programming - University of Technology Sydney - Write Financial Settlement System for a Smartcard Transaction Centre

Reviews

len2314042

5/30/2019 3:33:35 AM

Each task is worth 3.25 marks. The marking criteria for this assignment is: Analysis identifies all PKs and functional, partial and transitive dependencies. Accurately identifies all 3NF relations, including PKs, relevant attributes and referential integrity constraints. Creates an ERD that represents all 3NF relations and includes all entities, PKs, attributes, relationships, associative entities (if applicable), cardinalities and optionalities. Either save your diagrams in a PDF file or embed them in a Word document. Don't use any other file formats. Please include your student ID, name and subject code in your submission.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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