Draw an ER diagram for your proposed database

Assignment Help Database Management System
Reference no: EM131099002

We need

1. Describe the situation. Your description should be brief and relatively informal (maximum length 1 A4 page). If there are any unique or particularly difficult aspects of your proposed application, please point them out. Your description will be marked only on suitability and conciseness

2. Include a list of business rules (can make assumptions as long as it is logical)

3. Draw an ER diagram for your proposed database. You need to show attributes, primary keys, and relationships (needs to use Chen and Crows feet notation)

4. Normalisation of Diagram to 3NF

Reference no: EM131099002

Questions Cloud

Calculate contribution margin ratio at the projected levels : You are pitching a marketing proposal to a company that sells electronic equipment. For a particular product line, their current sales price is $20 per unit, cost is $9 per unit and they have $20,000 in fixed costs associated with this line. Calculat..
Should the state of texas implement term limits : Should the State of Texas implement term limits for our members of the appointed boards and committees, since most boards and committees handle the day-to-day operations of state government? Why?
How will activity impact work as nonprofit administrator : What field of nonprofit activity do you believe is experiencing the most changes and why? How will this activity impact your work as a nonprofit administrator.
Construction equipment-trailers and crutches : Round Table Rental Yards provides construction equipment, trailers, crutches, etc., on short-term rentals. Historically, Art, the owner, has purchased the items that he rents out, but his business has been expanding so rapidly that he is considering ..
Draw an ER diagram for your proposed database : Describe the situation. Your description should be brief and relatively informal. If there are any unique or particularly difficult aspects of your proposed application
Job description of a certified public accountant : Write the answer as a discussion post. What is the job description of a Certified Public Accountant?
How would a contemporary of monets feel about the image : In looking over this painting, how does it seem to capture both the promise and the threats of the emerging modern world? How would a contemporary of Monet's feel about the image and the scene it portrays?
Find three recent scholarly articles : What are some of the reasons for the reported growth of the nonprofit sector in the United States? Find three recent scholarly articles (2005- present). Compose a 3 - 5 page APA paper summarizing each of the findings from the text and the three ar..

Reviews

Write a Review

Database Management System Questions & Answers

  Compute numbers of married men-single men from table

Compute the numbers of married men, single men, married women and single women. Print these numbers on a student summary report.

  Write set of relational schemas-identify primary-foreign key

Sketch an E-R diagram which reflects the above reuirements. Write a set of relational schemas and identify primary and foreign keys. Try not to include redundant schemas.

  Display the results in descending order by the gross sales

Display all the columns from the Orders table that were paid with a Visa Card and have been shipped to the customer (hint: not a null). Order results by the Item Price in descending order.

  Questions related to normalization

Determine the steps in the development of an effective Entity Relationship Model (ERM) Diagram and determine the possible iterative steps / factors that one must consider in this process with consideration of the HR core functions and responsibili..

  Does the design include screens for the entire database

In this assignment you will be given a database and will create a user interface for it using the best practices that you have learned in the course. In industry designing and building a user interface takes months or even years to complete. We do..

  What kind of information will be included in the database

To design a database, a database planner should spend a considerable amount of time thinking about what kind of information will be included in the database and how it will be organized. There are several approaches to creating a successful datab

  Prepare a dfd and context diagram for the system

Journal entries have to be reconciled with the spreadsheet on a daily basis - Prepare a context diagram for the system and also prepare a diagram 0 DFD for the system

  Knowledge and data warehouse hi there i need to start the

hi there i need to start the assignment for data warehouse where i need to define assignmentyou are required to design

  Study on managing the software enterprise

This course is for those in a management capacity, or those interested in management, involving the strategic consideration of software acquisition, development and project management.

  Construct a model-theoretic interpretation

Construct a model-theoretic interpretation of the above rules using the given facts - State a rule that computes the first cousins of the following variety: their fathers must be brothers

  Create spreadsheet that contains three separate data sets

Identify your dream vehicle (plane, automobile, boat, etc.) and estimate its cost and the interest rate if you financed its purchase. Enter data (loan amount, interest rate, term, etc.) onto spreadsheet and use the PMT function and cell references..

  Develop a uml class diagram that illustrates the data items

Develop a UML class diagram that illustrates the data items for your program. List the decisions the program must make. References to the data items in the previous step should be used where appropriate

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