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

Describe the different procedure performed in dbms

Describe the different procedure performed in DBMS for student database in which fields are student id, student name, student class, marks.

Create database tables with appropriate field-naming

Identify and create database tables with appropriate field-naming conventions. Then, identify primary keys and foreign keys, and explain how referential integrity will be ac

Write a statement of work to present to wild wood management

Wild Wood Apartments owns 20 different apartment complexes in Washington, Oregon, California, and Idaho. Write a statement of work to present to the Wild Wood management

Create an erd for each of the following statements that

Create an ERD for each of the following statements that describe the current business rules for HTH. For each new statement being the business rule, extend the ERD to include

Create a relational database design for the data model

Create a Relational Database Design for the data model you developed for where you've added Projects and Supplies - Remember that in a database design you cannot have N:M rel

What is difference between partial and total completeness

A local college recruits both full time and part-time staff. How will you illustrate this scenario using a specialization hierarchy (include some sample attributes). From yo

Examine the use of databases in organization

Create a 2-3 page (350 words per page) examining the use of databases in organization. Explain what database applications are utilized (Microsoft Access, DB2, Oracle, etc.).

Create one table representing normalized design

Create one table representing normalized design (3NF) for the important objects and their attributes in a textbook catalogue and accounting office at a university book store

Reviews

Write a Review

 
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