Design the logical structure of a database

Assignment Help Database Management System
Reference no: EM131171047

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 11.55 PM, August 18, 2016 and must include:

- What you will do with the given tasks: task 2, task 3 and the dates (timeline) by when they will be completed
- General overview of initial understanding of solutions to task 2 and task 3
- Identification of Literature Resources

Task 2:

Scenario:

Nissan Motors Company (NMC) has several brands. Each brand has several models. The details of brand are the brand name and number of employees. The details of model are model id (unique), model name, year, engine, transmission and color. A given model belongs exactly to one brand. A model has one or more vehicles. NMC has several dealers that are responsible for selling different types of vehicles to customers. A dealer is identified by a unique dealer id. The other attributes are dealer name, location, phone and email. A dealer makes sale agreement with one or many customers. Similarly a customer may have a sale agreement with one or more dealers. Customer is identified uniquely by a customer id. The other attributes are name, company name, gender, address, phone, email, annual income. A customer may own many vehicles or may not own a vehicle. A vehicle may be owned by only one customer or may not be owned by any customer. A vehicle is identified uniquely by a vehicle number and vehicle location. One or more dealers may have access to a vehicle or may not have access to it. A vehicle may be accessed by a dealer or may not be accessed. A vehicle is produced by only one manufacturer. A manufacturer may produce one or more vehicles. A manufacturer is uniquely identified by a manufacturer code. It also has other attributes such as name, address, phone, email.

a) Construct the Entity Relationship Diagram (ERD) for the above given scenario. Identify all the entities, attributes of each entity including primary key, relationship between the entities and cardinality constraints.

b) Describe how the arrived logical design in task 2a above can be improved or enhanced by providing your suggestions and the rationale for the same.

Task 3:

a) Normalize the below given Rental Form to First Normal Form, Second Normal Form and Third Normal Form.

Alamri Rentals No 43, Al Hail, Sultanate of Oman

Owner ID: 98723415                                                              Rental code: 34l921

Owner Name: Maryam                                                           Date:  19 July 2016

Owner address: No 64, Al Hail, Muscat                                 Agent ID: 792

Sultanate of Oman                                                               Agent Name: Khamis

                                                                                             Agent position: Supervisor

Property Code

Street

City

Type

Client Code

Client name

Client

Telephone

1

Nakheel

Nizwa

House

112

Amna

9745671

2

Beach Road

Sohar

Villa

210

Balqees

9532693

3

Ruwi Main

Muscat

Shop

340

Mohammed

9253535

b) For the finally arrived normalized form in task 3a above, discuss how the redundancy has been minimized and what do you think will it achieve.

Task 4: Be ready for a written viva to demonstrate your knowledge with the different concepts used in preparing the assignment. Schedule for the written viva will be announced in the class and on Moodle/MEC mail. Marks for task 2 and task 3 will depend on the written viva.

Note: Task 4 is compulsory. No marks will be awarded to tasks 2 & 3 if written viva is not taken by a student.

Guidelines
Follow the guidelines mentioned below for your assignment.

- Submit a work proposal detailing aspects such as initial understanding of the given tasks, timelines to complete each task, literature sources for solving the tasks.
- Assignment should be typed and uploaded to Moodle and will undergo plagiarism detection test through Turnitin (a plagiarism detection tool)
- Handwritten assignments will not be accepted.

- Assignment should have a Title Page. Title Page should contain the following information.
 Assignment Name
 Class
 Student name
 Student ID
- It should have Table of Contents
- Use page numbers
- Assignment should be typed in your own words using Times New Roman font size 12.
- Heading should be with Font Size 14, Bold, Underline
- Use Diagrams and Examples to explain your topic.
- Copy paste from the Internet or other student work is strictly not acceptable.
- References should be included in the last page as follows
 Author name, Book Title, Publisher, Year in case of books
 In case of web site references type the full path of the web page with referenced date
 In case of journals/magazines/periodicals type article name, magazine name, Issue Number and date

Verified Expert

Reference no: EM131171047

Questions Cloud

How the issue was addressed by appropriate administrators : Discussion on how the issue was addressed and handled by appropriate administrators. A detailed description of the ethical issue, stating only the facts and not offering any recommendations at this point.
Term paper using agile project on mobile development : Term Paper Using Agile Project on Mobile Development- Suggest an agile project framework to your sponsors justify the agile best suited for this project.
Effective way of negotiating collaboratively : Why is "expanding the pie" an effective way of negotiating collaboratively? From a competitive approach, Principled Negotiation may appear weak. According to the authors of your text, strength or toughness comes in the form of
Explain the organization of the federal reserve system : Explain the organization of the Federal Reserve System. Explain reserve requirements. Explain the three types of unemployment. What is the difference between the nominal interest rate and the real interest rate? What are the four functions of money?
Design the logical structure of a database : Design the logical structure of a database using Entity-Relationship diagram - Apply normalization techniques to reduce redundancy in a database.
Describe the fires and discuss two socioeconomic factors : describe the fires, and discuss two socioeconomic factors that you believe most contributed to these fires, and why.
How the results of the regression were interpreted : Explain why the author(s) employed the regression technique presented in the article and how the results of the regression were interpreted. Finally, explain one conclusion you drew or insight you gained about using regression analysis in criminal..
System of strategic thinking : They present a three level system of strategic thinking that starts with self-awareness. At the top of the system, we are creating! Within this hierarchy, we must first master level one. Within the first level is critical thinking and being open m..
Booking vacations to europe for the coming year : European vacations are getting cheaper than they have been in years. With the dollar gaining 14.6 percent on the euro and 12.1 percent on the British pound over the past 12 months, large numbers of U.S. tourists are already booking vacations to Europ..

Reviews

Write a Review

Database Management System Questions & Answers

  Create a new tab named sales data answers

Create a new tab named "test data answers". Create a new table on your new tab to display the following information: average value for meas 1 and average value for meas 2.

  Distribution of resource consumption

Compute the activity rates for the Filling Orders and Product Support activity cost pools by filling - Distribution of resource consumption

  Assume that you have an array of baseball scores type

suppose that you have an array of baseball scores type integer called scores. the values in the array are ordered from

  Create an erd from a business problem

List all the business rules for the ABS ( Business rules are important because they define the conditions that the database must meet. For example, every Order must be associated with a valid Product.This prevents invalid Orders being entered into..

  List course along with names of students from database table

List the courses (D-code and C-no), along with the names of the students who are currently taking them. List all the courses (D-code and C-no) that John (i.e., S-Name=''John'') got 'A' grade.

  Provide a logical and physical design

Design and develop a database using professional principles and standards. Provide a logical and physical design of the database.

  Information about clients and projects

A software company has the following information about its clients and the projects given by them: Clients (client number, client name, address)

  Provide an unique example of a supertypesubtype

provide an unique example of a supertypesubtype relationship. be sure to describe the relationship and discuss if the

  Develop an er model

You are required to develop an ER model to represent the information requirements for a database that Queensland Liquor National online trader system will use as described on last page.

  Differentiate between a flat file and a relational database

Determine when a sequential file is more useful than a database. Differentiate between a flat file and a relational database

  Write-up thoughts on the tutorial

Write-up thoughts on the tutorial on given tutorials: 2005 Tutorials

  Describe various relational database management systems

Create an xml representation of data describing various relational database management systems (e.g. Microsoft SQL Server, MySQL, ...). The data for each database should include (but is not necessarily limited to) info like name, vendor, current v..

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