User Account

All Pages

Build a entity relationship diagram

Assignment Help Basic Computer Science
Reference no: EM131587933

Begin by analyzing the requirements provided. Identify the tables, fields, field attributes, and table relationships required.

Build a Entity Relationship Diagram that models the required tables and relationships using Microsoft® Visio®, Lucidchart, or another software tool of your choice. The table design and relationships must support the following functionality:

  • Customers - Each customer is assigned a unique customer number but may have multiple locations to ship to. The sales team needs to be able to select the customer and the location for preparing sales orders.
  • Inventory Table - The sales team will want to query the inventory to find diamonds that meet the following specifications of their customers:Cost - what SD has paid for the stone
  • Price - what SD will sell the stone for
  • Carat - weight
  • Clarity - clarity scale for diamonds offered are IF, VVS1, VVS2, VS1, VS2*
  • Cut - cut scale for diamonds offered are Excellent, Very Good, Good
  • Color - color scale for diamond offered are D, E, F, G, H, I, J*
  • Order Table - The sales team will want to a sales order for existing customers and sell only diamonds that are in inventory. The DBMS must be designed such that customers can purchase multiple stones on one sales order.

Team Project but I'd like help with it as well as a description of the process.

Reference no: EM131587933

Questions Cloud

Explain leadership skills your learning team identifies : Explain Leadership skills your Learning Team identifies with the most. How this information will help you work as a group during this course.
The influence of drugs or alcohol face incarceration : Should individuals who are arrested and convicted of a crime while under the influence of drugs and/or alcohol face incarceration, treatment, or both?
Organizations seeking it services : Buyer organizations seeking IT services usually require an oral presentation, with questions and answers, from the final several potential contractors.
Analyze the validity and constitutionality of officer jones : Analyze the validity and constitution Identify the constitutional amendment that would govern Officer Jones' actions
Build a entity relationship diagram : Build a Entity Relationship Diagram that models the required tables and relationships using Microsoft® Visio®, Lucidchart, or another software tool.
How does that belief affect treatment choices - or does it : Although genetic research is inconclusive, what is your belief about the genetic predisposition to alcohol?
The effects of drug seeking behavior : Describe the so-called "brain reward pathway" and explain its importance to understanding the effects of drug seeking behavior
Explain the key components of the inventory : Explain the key components of the inventory. Give examples of at least three questions that need to be asked and address prospective loopholes.
Providing security for an organization : Providing security for an organization can be a costly venture. The cost of safeguarding our information and resources.

Reviews

Write a Review

Basic Computer Science Questions & Answers

  What whistle-blower actions did dr. wigand take

What motivated Wigand to take an executive position at a tobacco company and then five years later to denounce the industry's efforts to minimize the health and safety issues of tobacco use?

  Shortly after the introduction of the computer

Shortly after the introduction of the computer, someone said that two computers could undertake all the computing in the World. At that time the best computers were no more powerful than today's pocket calculators. The commentator assumed that com..

  Training program explaining net present value

You have been asked by a manager in your organization to put together a training program explaining Net Present Value (NPV) and Future Value.

  What is the minimum required bandwidth of the channel

A digital signaling system is required to operate at 9600 b/s, If a signal element encodes a 4-bit word, what is the minimum required bandwidth of the channel?

  Write a statement to print the counter value

Write a For loop such that the loop till iterate from 1000 to 1 decrementing the counter by 1 each time through the loop. Inside the loop, write a statement to print the counter's value to the Output window.

  Part of the hipaa privacy rule

True or Flase. As a patient, your doctor must sign a HIPAA Consent and Release Form to share your ePHI or PHI with insurance providers who pay for your medical bills. This is part of the HIPAA Privacy Rule.

  What technical skills do these jobs require

what companies would you do well for as a social media manager? What steps should you take while in school to prepare yourself for a career as a social media manager?

  Demonstrate a reduction from the former to the latter

demonstrate a reduction from the former to the latter.

  Where does this energy come from

Is heat transfer to or from the fluid desirable as it flows through a nozzle? How will heat transfer affect the fluid velocity at the nozzle exit?

  What is the cost associated with such interfaces

Why is it important to have stable and testable interfaces among the subsystems of a large system? What is the cost associated with such interfaces? Why is it difficult to define error-containment regions in a centralized architecture?

  Flexible solution for the consultants

What will adding a flexible solution for the consultants to connect to the network do to this risk model? What are some safeguards that can be implemented to reduce the risk?

  What does the sql query

What does the following SQL query do? sqlStr = "SELECT* FROM computers WHERE Speed >2 AND Memory > 4 ORDER BY OS-Type"

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd