Solution-Identify the primary key for each table

Identify the primary key for each table

Assignment Help Database Management System

Reference no: EM132121135

Relational Database Exercise:

You have been assigned to a new development team. A client is requesting a relational database system to manage their present store with the anticipation of adding more stores in the future.

You received an email from the client with the list shown below. Currently, this list tracks their daily business. To prepare for the meeting with the client, you develop a first draft prototype.

In a one page MS Word report include the following:

1. Table(s) needed

2 Fields for each table

Name at least 7 additional fields.

Which field or fields shown below do not belong in a table? Explain.

Identify the primary key for each table.

Draw the tables showing relationships between tables.

Develop 3 questions to ask client at your face-to-face meeting next week that will assist in refining the prototype.

LastName	FirstName	InvoiceDate	InvoiceItem	Quantity	Price	Tax	Total
Shire	Robert	12/14/2012	Antique Desk	1	3000	249	3249
Goodyear	Katherine	12/10/2012	Dining Table	1	1000	83	1083
Tierney	Doris	12/23/2012	Book Shelf	1	250	20.75	270.75
Anderson	Donna	12/22/2012	Desk Lamp	1	45	3.74	48.74
Shire	Robert	12/14/2012	Antique Chair	2	125	20.75	270.75

Reference no: EM132121135

Questions Cloud

Write about your observations on timing measurements : You should redirect the output of each program to an out.txt file. You should write about your observations on timing measurements in a separate text or pdf fil

How you are going to control the loading of this register : Register design A CPU register is simply a row of flip-flops (i.e. SR, JK, T, etc) put side by side in an array to make the size of register required.

What are static variables and instance variables : What is constructor? the purpose of default constructor?What are static variables and instance variables?

Identifies the key features of the organization : M5A3 Research Project - Write a short paper that identifies the key features of the organization's performance management system

Identify the primary key for each table : A client is requesting a relational database system to manage their present store with the anticipation of adding more stores in the future.

How many bits does the address bus have : A register is the fastest data storage element within a processor. A 32-bit register consists of a set of flip-flops to store 32 bits of information.

Draw a transition graph for machine n : Draw a transition graph for machine N. Consider using JFLAP unless you have another tool you know for the problem.

How might these analyses promote or empower effective : How might you apply the model developed in the article to your organization or an organization with which you are familiar?

What is the value of r : Consider the 5-bit generator, G=10011, and suppose that D has the value 1010101011. What is the value of R?

User Account

All Pages

Identify the primary key for each table

Reference no: EM132121135

Reference no: EM132121135

Questions Cloud

Reviews

Write a Review

Database Management System Questions & Answers

Knowledge and data warehousing

Design a database schema

Entity-relationship diagram

Implement a database of courses and students for a school

Prepare the e-r diagram for the movie database

Design relation schemas for the entire database

Prepare the relational schema for database

Data modeling and normalization

Use cases perform a requirements analysis for the case study

Knowledge and data warehousing

Stack and queue data structure

Practice on topic of normalization

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT