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

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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