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

  Do that most companies need this type of implementation

Do you think that most companies would need this type of implementation? Why?

  Data-flow diagrams can be used to the physical system

Data-flow diagrams can be used to model both the physical and logical systems. Data models can be analyzed to identify possible inconsistencies that exist between two sets of diagrams or within a single DFD.

  Why are labor operations and labor types often tracked in

Why are labor operations and labor types often tracked in the conversion process but usually not tracked in the revenue process?

  Write a program to keep track of a cd or dvd collection.

write a program to keep track of a CD or DVD collection. This can only work exclusively with either CDs or DVDs since some of the data is different. The data will be stored ina file. The data from the file will be stored ina text file as records. Eac..

  Identify department store transactions that can be stored

Identify the potential sales and department store transactions that can be stored within the database. Justify how Big Data tools could be used for forecasting sales and inventory of the department store.

  Managing information and databse

Write 7 page about managing information and databse

  Perform a functional dependency analysis

Perform a functional dependency analysis, and include it as part of your deliverables, for every step of the normalization process - Redesign the spreadsheet into a database with tables, add any fields that you think could be useful, even though it..

  Ensure the security of organizations distributed database

How can you make your database more hacker proof? How do you ensure the security of an organizations distributed database?

  Imagine that you work for a consulting firm that offers

imagine that you work for a consulting firm that offers information technology and database services. part of its core

  Creating erd containing order and customer entity

Create ERD containing Order and Customer entity types connected by 1-M relationship from Customer to Order. Select suiatble relationship name using your common knowledge of intersection.

  Why scm system is different than srm system

SCM in ERP- Report should be a detail report that highlight the importance of SCM systems. The Report should show the difference: why SCM System is different than SRM System

  Edinburgh airport officials are concerned about complaints

edinburgh airport officials are concerned about complaints received by the service department and are about to do an

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