We're Open
+44 7340 9595 39
+44 20 3239 6980

[Solved]Module 2 Case: Entity Relationship Model Database Design

  100% Pass and No Plagiarism Guaranteed

[Solved]Module 2 Case: Entity Relationship Model Database Design

Module 2 Case: Entity Relationship Model Database Design

INSTRUCTIONS:

Module 2 - Case
ENTITY-RELATIONSHIP MODEL AND DATABASE DESIGN
Apply what you learned in the following exercise:
Explain why the entity relationship (ER) model is useful. How has it helped to produce a more structured relational database design environment?
Tables in an Electronics Store
A fairly large local electronics store contracts with you to develop a database system for them. Your first task is to design a table for the store`s employees.
Even many of the most experienced designers "sketch" a design on paper before they start creating the database in electronic form.
Please "sketch" an employee table (basically what data items or columns should be included in the table) using the template below as a model.
The CEO of the store tells you that the following information must come from the table.
List/display of all employees showing social security number, first and last name, address, city, state and zip code, birth date, full-time or part-time status, salary (hourly rate) and date of hire.
The total number of employees.
List/display of all employees making more than a certain hourly rate, say $20 per hour.
List/display of all employees hired within a time period, say last year.
"Template" for Employee`s Table
EMPLOYEE TABLE
Social Security Number
The data items that belong in a table are a function of the information that has to come out of the table. Therefore, the determining factor is the information requirements that have been given to you.
This is your assignment:
Part I
Enter the data items in the column headings in row one that you believe should be in this table. In doing this, you are actually designing the table.
Paste your table into a document.
Go to Part II below and complete the assignments there.
HINTS for Part I:
You need not be concerned with the rows (except for row one, of course).
The first column of the table is the Primary Key (social security number). This has been filled in to give you a start.
Match what`s in your table to the information requirements to make certain all data has been included.
Totals that are derived from the table through computation do not have to be carried in the table.
Part II (Required)
Your work is so good that the electronics store contracts with you to do additional work for them. Your next task is to design two tables that relate to one another. These tables are: the Customer table and the Sales Order table.
The Customer table contains the basic data on each customer, and the primary key is the customer number. There is one row for each customer.
The Sales Order table contains the data for each sale. The primary key consists of two pieces of data: sales order number and customer number. There can be one or more sales orders for a customer, but only one customer on a sales order.
Use the templates below to design the two tables.
"Templates" for Table Design
Customer Table
Sales Order Table
Case Assignment
Entity-Relationship Modeling
Fill in the column headings in row one of each table with the data items you believe belong in the table.
Cut and paste your tables into the same document from Part I.
Suppose the Sales Order table also contains information for an employee who makes a sale. Draw an ERD of your complete design for the electronic store. If you have an ERD drawing tool such as Visio, you could draw the diagram using the tool and copy it into your document. You could also draw it on paper, scan it, and insert it into your document. If you can’t do either of the above, you could write down the table schemata and describe the relationships among them.
Submit the document. Make certain the table title, course number, and module and Case ID are on the work you submit.
Describe the major points you learned in the readings especially on entity-relationship modeling and what lessons you have learned in this exercise. (at least half a page).
HINT: Search the Internet to find help either in the form of examples or similar problems or tutorials.
Assignment Expectations
Design tables based on domain requirements.
Represent database design using ERD.
Communicate effectively with your audience.

CONTENT:

Case Entity-Entity-Relationship Model Database Design Name Institutional Affiliation Case Entity-Entity-Relationship Model Database Design Course Number: Module 2 Case ID Part I Employee Table Social Security NumberFirst NameSecond nameAddressCityStateZip CodeBirthdateStatus (full/part time)Salary (hourly rate)Date of hire Part II Customer Table Customer NumberFirst NameSecond NameEmailTelAddressCityStateZipCustomer since (date) Sales Order Table Sales order numberCustomer numberSocial Security NumberSale Amount DateComment ERD Design for

...

100% Plagiarism Free & Custom Written,
Tailored to your instructions


International House, 12 Constance Street, London, United Kingdom,
E16 2DQ

UK Registered Company # 11483120


100% Pass Guarantee

STILL NOT CONVINCED?

View our samples written by our professional writers to let you comprehend how your work is going to look like. We have categorised this into 3 categories with a few different subject domains

View Our Samples

We offer a £ 2999

If your assignment is plagiarised, we will give you £ 2999 in compensation

Recent Updates

Details

  • Title: [Solved]Module 2 Case: Entity Relationship Model Database Design
  • Price: £ 89
  • Post Date: 2021-11-04T12:49:32+00:00
  • Category: Essays
  • No Plagiarism Guarantee
  • 100% Custom Written

Customer Reviews

[Solved]Module 2 Case: Entity Relationship Model Database Design [Solved]Module 2 Case: Entity Relationship Model Database Design
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

My order went 3 hours late and I also went mad. Then the customer support team calmed me down and offered me a flat discount of 50%. However, I did get my order and chilled out as the work was exactly what I requested. Next time I would place my order a bit sooner to save any trouble.
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

The rates are a bit expensive for me of the essay writing service but the overall look is amazing. The references and formatting are done beautifully. So, I feel that the high rates are worth all these qualities. I want to thank you for great help.