Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Objective: This is an individual assignment aimed to give the student exposure in understanding, designing, building and analyzing database systems for a given real-time based scenario and be able to conduct optimal strategies for efficient management of databases.

Intended Learning Outcomes covered:
1. Design the logical structure of a database using Entity-Relationship diagram.
2. Apply normalization techniques to reduce redundancy in a database.

Task 1:
Complete the work proposal in Microsoft Word file format (may include possible answers based on your initial understanding). Work proposal for the assignment must be submitted before the end of week 7 and must include:

a) Understanding of deliverables - a detail description of deliverables.

b) General overview of proposed plan - initial understanding of solution to task 2 which includes, the name of entities, associative entities and relationships. Initial understanding of solution to task 3.

c) Timeline for completion of task 2 and task 3.

The work proposal must be submitted in a word file through the link available in Moodle.

Task 2:

Scenario:
Fun Studio provides exciting games, exciting rides for children in Oman. It offers several games to entertain its customers. Each game has an ID, name, duration. Once a customer visits the center, the Customer Relation Officer will record the details of the customer such as name, contact number, address and residence ID number, which is unique to every customer. Customer can choose any number of games or he may not choose any game, a game can be chosen by at least one customer. Whenever a customer chooses a game, the date and score will be recorded to calculate the credits of the customer. The recreation center offers different royalty programs such as diamond, platinum, gold, and silver to all its customers. Each program has program code, name, term and price. A customer can buy any number of royalty programs, or may not buy one. A royalty program will be bought by at least one customer; otherwise the center cancels the program. When a customer buys a program, the center wishes to record the date to maintain the term of the program.

a) Construct the Entity Relationship Diagram (ERD) for the above given scenario. Identify all the entities, associative entities, attributes of each entity including primary key, relationship between the entities and cardinality constraints. State any assumptions necessary to support your design.

b) Analyze the above given scenario and discuss about the possible structure of the relations (the number and name of the columns) and the referential integrity constraints to be implemented in the above design.

Task 3:

a) Normalize the below given Attendance Summary Report to First Normal Form, Second Normal Form and Third Normal Form. Make assumptions for the identification of the primary key wherever necessary.

b) Discuss how the data consistency can be maintained during normalization for each normal forms. Support your answer with reference to the above Question. (At least 400 words)

Nizwa College
Student Attendance Summary

Student ID: M1S27778                                Attendance Summary Code: AD104
Student Name: Ahmed Al Haldirami             Summary Period: Summer 2017
Specialization: Electronics                           Summary Date: June 15, 2017
Attendance Details:

MCode

M_Name

Module Description

Instructo
r ID

Instructor
Name

Total Hours

Hours
Absent

E0001

Electronics Engineering

Basics,            methodologies

and                    Designing

approaches

MEC12

Mr.
Quraishi

50

5

E0005

Circuit Basics

Circuit concepts

MEC67

Mr. Ahmed

40

6

E0004

Design Engineering

Basic Electronic
engineering concepts

MEC34

Ms.
Samreena

65

7

E0007

Introduction to Logistics

Logistics basics

MEC64

Ms . Jose

55

8

C0003

Fundamentals of Computer networks

Basic concepts of
Computer

MEC57

Mr salim

35

1

Task 4

Be ready to demonstrate your knowledge with the different concepts used in preparing the assignment.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M92575033
  • Price:- $50

Priced at Now at $50, Verified Solution

Have any Question?


Related Questions in DBMS

Instructionsfor decades relational databases remained

Instructions For decades, relational databases remained essentially unchanged; data was segmented into specific chunks for columns, slots, and repositories, also called structured data. However, in this Internet of Thing ...

Sql assignmentin these exercises youll enter and run your

SQL Assignment In these exercises, you'll enter and run your own SELECT statements. You will use the MyGuitarShop database for these queries. If you do not already have the MyGuitarShop database, the SQL script and the i ...

Data model development and implementationpurpose of the

Data model development and implementation Purpose of the assessment (with ULO Mapping) The purpose of this assignment is to develop data models and map Database System into a standard development environment to gain unde ...

Systems analysis project scenic routes operates a bus

Systems analysis project Scenic Routes operates a bus company that specializes in travelling on secondary roads, rather than Interstate highways. Their slogan is: "It Takes a Little Longer, But It's Scenic." The firm nee ...

Students will select a situation or problem from their

Students will select a situation or problem from their company as a course project that can be solved using a database system. Using MS Access, or MS SQL Server Express, students will create a relational database model o ...

Question as explained throughout this course entity

Question: As explained throughout this course, entity relationship modeling is a critical element of database design. If the database is not properly modeled, it is unlikely that the database will be properly developed. ...

We can represent a data set as a collection of object nodes

We can represent a data set as a collection of object nodes and a collection of attribute nodes, where there is a link between each object and each attribute, and where the weight of that link is the value of the object ...

Assignmenta restaurant is designing a database to keep

Assignment A restaurant is designing a database to keep track of customer services. A customer is defined as a customer ID, name, address and a telephone number. Customers are served by employees. Each employee is define ...

Questionsuppose a prolog database exists that gives

Question: Suppose a Prolog database exists that gives information about states and capital cities. Some cities are big, others small. Some states are eastern, others are western. a. Write a query to find all the small ca ...

Tableau is business intelligence software that helps people

Tableau is business intelligence software that helps people see and understand their data. Fast Analytics Connect and visualize your data in minutes. Tableau is 10 to 100x faster than existing solutions. Ease of Use Anyo ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As