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

  Write a monitor using to implement readers-writers problem

Suppose that we replace the wait and signal operations of monitors with a single construct await(B), where B is a general Boolean expression. Write a monitor using this scheme to implement the readers--writers problem.

  Briefly how to make use of indexes such as b+ tree

Summarize briefly how to make use of indexes such as B+ tree or a hash indexes in selection, projection, and join operations?

  Explain new objects based on extending other objects

One of the new classes must be based on a reference extending an existing class from package task02 directly(similar to how Customer extends Person in the sample code).Do not repeat that package task02 class in the task03 package.

  Convert the erd into tables in access

Convert the ERD into tables in Access. Submit screenshots. Use Access tools to generate forms for users to populate the tables.

  Database system development the database application

database system development the database application project dap for this course consists of the creation of a fully

  Define the relationships between the tables

Using Microsoft Access create the tables and relationships defined in your data model. Your Microsoft Access Database at this point should include the following: The Tables as defined in your Entity Relationship Diagram. The Relationships between t..

  List all the functional dependencies that this relation

Assume that the value of attribute Z of the last record in the relation is changed from z3 to z2. Now list all the functional dependenciesthat this relation instance satis?es.

  Delete an existing product from the database

Utilise an include statement to refer to connection.php instead of the long version of the database connection code so that you can keep the database more secure. See Notes for more details.

  Implement a new learning management system

Its a lead a project that will implement a new learning management system for your university. You have two key tasks: Task 1: Investigate learning management software packages that are available through application service providers.

  Determine a list of n numbers has no duplicates

Express given five loosely described problems carefully in { Instance, Question } form as utilized in "Computers and Intractability". Determine that a list of n numbers has no duplicates.

  Consider the following set of database tables same tables

consider the following set of database tables same tables from assignment 6-1. please take note of foreign keys most of

  Develop the ipo chart, flowchart, and pseudocode for an app

You will need to develop the IPO Chart, flowchart, and pseudocode for an application that it will prompt a user for their hourly pay rate, their hours worked, and whether they are single, married, divorced, or widowed.

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