Create an e-r diagram

Assignment Help Database Management System
Reference no: EM1341091

Assignment 3.2 Database notation is not consistent. You have probably seen that already when you tried to create an E-R diagram. Visio uses notation and graphical shapes that are not the same as those in your text. If you look at some of the links to schemas, you will see a similar sort of thing.

  • In your own words, discuss why these differences exist and what, if any, solution you would recommend.
  • Feel free to use the Web to research this topic
  • Remember to list your sources.

Assignment  3.3: Uncle Bob's Home Repairs .Bob Harris owns a small company called Bob's Home repairs. He does the small home repair jobs that the large companies pass by. Need some wood work or wood furniture fixed? Call Bob. Here is how the business works:

Someone calls Bob and asks him to bid on a job. He drives over, looks at the situation, and gives them a bid. Sometimes it is an official looking bid by mail, and sometimes it is scribbled on notebook paper. He decides how long it will take to do the job (he bills by the hour), how much wood will be needed, any odds and ends that are unique to the job, and an overall price. He moves from job to job and bills customers as he finishes the work.

Bob buys items and supplies from a variety of places, but he buys only what is needed for a particular project. A potential problem: if he gets behind on his payments to various suppliers, then they won't let him order any more. This would stop his business dead in its tracks. His biggest and most crucial supply is lumber (the price rises and falls constantly). So, he must pay all bills within 30 days of receiving them, especially the lumber companies.

Bob is pretty nice to his customers. They don't have to pay until the work is completed and they are satisfied with his work. This has occasionally led to some problems because the cash coming in is sometimes slower than the cash going out, and he would like to have a better idea of when his bills are due and when his customers will be paying. Currently, all business records are kept in Bob's head and in one file cabinet. Sometimes he forgets which jobs he bid on and how much he bid on them. He doesn't call potential customers to ask about earlier bids, but this could increase business. He wants reports on suppliers that need to be paid and customers that are slow in paying their bills. So, he wants to computerize these aspects of the business to make things more efficient. Can you help him?

Here is what you need to be able to provide Bob in order to land your first consulting contract:

1.Week 3 - An individual E-R diagram.

2.Week 4 - A group E-R diagram.

3.Week 5 - A group data dictionary.

4.Week 6 - A script that will create the tables and enter a minimum of 3 sets of data for each table.

5.Week 7 - Some sample queries.

6.Week 8 - Slides.

Here is what you don't need to do: You don't need to computerize the entire business, just the processes that Bob's Home Repairs finds most bothersome. You don't need to create forms for data entry. This is something you would do if hired as a consultant.

An outstanding project will have the following characteristics, with lower grades for projects that lack these things:

1.The E-R diagram clearly identifies the entities, relationships, and attributes.

2.The logical schema clearly identifies the attributes and required keys for each entity.

3.The tables are in third normal form, and you used good names for the tables and the fields.

4.The sample data is useful in creating sample reports.

5.The script works with Oracle using the the 10g XE interface.

6.The script has comments to make it easy to edit later. (dashdash space )

7.The sample queries that will show Bob's Home Repairs how the database will be useful in meeting his data needs.

8.The slide package summarizes your project and could be used for presentation.

This week, we will begin work on our semester project. I have assigned you to a group forum and given each group a scenario-based database project. This project will be completed as a series of activities with milestones. Use your assigned group forum to collaborate, work, and post your deliverables.

  • The first activity will be to analyze the assigned situation and to create an Entity-Relationship Diagram (ERD) for the project. There is a set of narrated slides that explains this process in the Narrated Power Point Slides folder in Course Documents.
  • Create this diagram using Visio, which is available from the Microsoft Academic Alliance. If you have never used Visio before, please complete the tutorial at the link in the reading assignments.
  • To get started, read the narrative for your assigned group project. Based on this narrative each of you will individually develop an ERD for the project. Be sure to include any "parent/child" relationships you may deem to be significant.
  • Attach a copy of your ERD to this assignment and post it to the file exchange for your group. This week's grade is an individual one, so please post your own ERD.

Reference no: EM1341091

Questions Cloud

Employer-at-will doctrine and liability of an employer : Explain what steps you would take to address the following scenario involving policies and procedures
Labor strikes - conflict and emotions : Labor Strikes: Conflict and Emotions - Prepare a short article and help people to understand a labor strike from both perspectives
Explain labor relations system : Which events do you feel were most important in shaping the labor relations system and Do you feel that earlier events from the nineteenth-century still have an impact today
Different roles - employee versus union member : Different Roles - Employee versus Union Member describe the difference between the two roles. Is it difficult to do both jobs effectively
Create an e-r diagram : You have probably seen that already when you tried to create an E-R diagram. Visio uses notation and graphical shapes that are not the same as those in your text. If you look at some of the links to schemas, you will see a similar sort of thing.
Show the labor relations flyer : Choose an organization that is associated with labor relations and the public sector and Research that organization and prepare a one-page, single-sided flyer which provides details about the organization.
Growth of the american labor movement : Show What factors in the 1800s do you believe contributed to the growth of the American Labor Movement and Please describe your answer
Labor relations - employer''s actions : Labor Relations: Employer's Actions - Explain What actions can an employer take to try to discourage their workers from organizing
Employers effect on unions : Employer's Effect on Unions - who report back to the employer on what is being well-received by the union members and what is not working.

Reviews

Write a Review

 

Database Management System Questions & Answers

  Prepare the relational schema for database

Prepare the relational schema for database

  Analyse a set of data and write a memo

To analyse a set of data, and write a memo, identifying and explaining your insights into the operation of Todd Restaurants.

  Write an sql query

Write an SQL query to get the author of the book "The Alchemist"

  Design a database schema

Design a Database schema

  What do you mean by data base scheme

Database Questions:  What do you mean by data base scheme?  What do you mean by cardinality ratio?   What do you mean by degree of relation?

  Create a database from scratch

Create a database from scratch that contains, at a minimum, the elements listed below

  Show the rea diagram using microsoft word

Show the REA diagram using Microsoft Word

  Draw an entity relationship diagram for the system

Draw an Entity Relationship diagram for the system and Identify the table design for the database displaying all the fields/attributes. Ensure that all tables are in 3NF. You also need to identify the primary keys and foreign keys, where applicable..

  Draw the e/r diagrams for the business rules

Draw the E/R diagrams for the business rules

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Study and modify the postgresql source code

Write a Assignment to study and modify the PostgreSQL source code, with a focus on one of the core modules - the buffer manager

  Draw an er diagram for database scenario

Draw an ER diagram for database scenario. Design a set of 3NF tables for your database scenario.

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