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

Question 1 unified communications system eg email

Question: 1. Unified Communications System (e.g., email, conferencing, and messaging) - The local area network is slower than needed, especially for newer, cloud-based applications. The email system needs refurbishment a ...

You are in a real estate business renting apartments to

You are in a real estate business renting apartments to customers. Your job is to define an appropriate schema using SQL DDL in MySQL. The relations are Property(Id, Address, NumberOfUnits), Unit(ApartmentNumber, Propert ...

Stored procedure please create the following stored

Stored procedure. Please create the following stored routines using CPS3740_2017S database using the tables in dreamhome database. xxxx is your email id 1) Implement a stored procedure p3Q21_xxxx to display the Branch ci ...

Question suppose we have two kinds of doctors hospital

Question : Suppose we have two kinds of doctors: hospital doctors and family physicians. In addition to the doctor's id number, name, specialty, and years of experience, we want to record the hospital name for the hospit ...

Select from e d pwhere edeptddept and dcitypcity and

Select * From E, D, P WHERE E.dept=D.dept AND D.city=P.city AND D.budget>1M AND P.priority=A; Assuming relations have the same size and uniform distributions, what is the best plan with Nested Loop joins only? Write it a ...

Relational database exerciseyou have been assigned to a new

Relational Database Exercise: You have been assigned to a new development team. A client is requesting a relational database system to manage their present store with the anticipation of adding more stores in the future. ...

Sql transactions exercisesconsider table itemnameprice

SQL Transactions Exercises Consider table Item(name,price) where name is a key, and the following two concurrent transactions. T1: Begin Transaction; Update Item Set price = 2*price Where name = 'pencil'; Insert Into Ite ...

Question 1 what isdata-manipulation language dml there are

Question: 1. What isData-Manipulation Language (DML)? There are four types of access in DML, explain each one. 2. Assume we have a Library Database consists of the following relations: author(author_id, first_name, last_ ...

In this section the student is required to develop a

In this section, the student is required to develop a technical debate based on his/her understanding using available scientific literature. The answer to this question should not exceed three A4 Pages. In the traditiona ...

Question find at least two academic sources that describe

Question: Find at least two academic sources that describe the movement of Enterprise resource planning (ERP) activities to the cloud. Discuss the types of ERP activities that can be conducted in the cloud and the pros a ...

  • 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