Create the preliminary database tables for the sales contact

Assignment Help Database Management System
Reference no: EM13950451

Using Microsoft Word, list all of the data fields that would be needed for a sales contact database system. Think of it as an extended address book with additional fields to keep track of things that interest salespeople. The only requirements are that you must consider how to store notes about the contact, track any follow up items, and store multiple phone number for each contact. Be sure to include the field type and size. Please do not jump ahead and try to create tables. Right now I'm just looking for a list of fields. This is somewhat vague on purpose. I want you to decide what is needed in the database.

This is what I did for the above instruction. And I want someone to help me by using Microsoft Access (Word or Excel are fine if you don't have Access), create the preliminary database tables for the sales contact system from above Question. Be sure to include field type and size. Indicate what fields you believe will be primary keys, foreign keys, and indexes.

Reference no: EM13950451

Questions Cloud

What is the primary key for each entity : Are there any multivalued attributes shown? If so, discuss how it/they should be handled in the implementation of the relational database.
Explain that decrease in price level leads to in real wages : Since nominal wages fell by the same percentage as the price level, you explain that a decrease in the price level leads to (no change, a decrease, or an increase) in real wages. This, in turn, leads to which of the following? Firms hire more work..
Why the estate was not subject to any federal estate tax : Explain why the estate was not subject to any federal estate tax. Assuming that the above information describes the activities of the estate and that all provisions of the decedent's will have been carried out.
What is jackel charitable contribution deduction : What is Jackel's taxable income? What is Jackel's charitable contribution deduction?
Create the preliminary database tables for the sales contact : create the preliminary database tables for the sales contact system from above Question. Be sure to include field type and size. Indicate what fields you believe will be primary keys, foreign keys, and indexes.
What is the golf course''s profit if there are 100 golfers : How does the golf course's profit per golfer in the above situation compare to the case in which the golf course is banned from charging a membership fee and can only charge a price per round of golf? Explain.
Prepare journal entries to record each of the given events : Prepare journal entries to record each of these events. Use the straight-line method of amortization where applicable.
Work out an acceptable solution to a problem : In trying to work out an acceptable solution to a problem, managers who rely on their understanding of other people and who empathize with others' feelings are using which managerial skill according to Katz?
Create a switchboard for your database : Do not use the Main Switchboard page that is provided for you, but rather create a new Switchboard named with your first name and the word Switchboard. (For example, mine is called Janis Switchboard.)

Reviews

Write a Review

Database Management System Questions & Answers

  If you cannot capture some constraints explain why

Consider the university database from Exercise 2.3 and the ER dia-gram you designed. Write SQL statements to create the corresponding relations and capture as many of the constraints as possible. If you cannot capture some constraints, explain why.

  How will your team c

What steps will your team take if you need to seize any digital evidence and What documentation processes will you follow to help support any potential legal proceedings?

  Draw an entity relationship diagram

Draw an entity relationship diagram (ERD) for the following situation: A company has a number of employees. Each employee is identified by an Employee_Id. The company wants to store Employee_Name, Employee_Address, and Employee_BirthDate in the d..

  Design database design for boingx aircraft company

You have been asked to design database design for BoingX Aircraft Company (BAC), that has two products: TRX-5A and TRX-5B HUD (heads-up display) units.

  Sales transaction in retail clothing

Examine different sales transactions. Design a context diagram and a level-0 diagram that represent the selling system at the store.

  Evaluate maximum rate at which data can be read from disk

What is the maximum rate at which data can be read from disk, assuming that we can only read data from one surface at a time? What is the average rotational latency?

  Implement a cluster using physical hardware

Implement a cluster using physical hardware, the process is very straightforward.But what if you want to implement a cluster using virtualization?

  When should we use relational database

If the problem is simple one should use a sequential or relational file and if the problem is complex one should choose to use a database?

  The relationships between the tables

At this point you have constructed your data model and it meets the definition of 3rd Normal form.

  What is the total i/o cost for sorting this file

How many sorted subfiles will there be after the initial pass of the sort, and how long will each subfile be?

  Seconds of elapsed time to execute

Suppose that a certain program takes 500 seconds of elapsed time to execute. Out of these 500 seconds, 280 seconds is the CPU time and the rest is I/O time. What will be the I/O time?

  Prepare a systems analysis report detailing ace''s problem

Additionally, the firm cannot tell whether its customers are more interested in no-frills cars or ones with luxury options. Prepare a systems analysis report detailing Ace's problem and a systems solution that can be implemented using PC database ..

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