HIRE A WRITER!
Paper Types
Disciplines

Relational Sales Database Model, Research Paper Example

Pages: 1

Words: 341

Research Paper

In the creation of a potential relational database model for a sales database, it is essential to identify the different entities to be included within the database and their different attributes (Ritchie, 2002). For our business, the following are the entities that will be present in the potential relational database model for sales.

Customers

Customer ID: each customer will have their own specific and unique customer ID to help identify the customer, the purchases they have made and their frequency of purchase.

Contact Information: each customer will have their contact information stored for future reference and delivery of products if need be.

Products

Product ID: each Product will have its unique ID to help trace the product from its production through sales. This will also help identify a faulty batch.

Batch Number:  each product batch sold will have its own unique batch number to help track each batch sold and even facilitate recall of a faulty batch.

Sell by Date: since the business deals with fresh and organic produce, it is essential that the products are maintained at optimum level of freshness. As such, all the products will have a sell by date tag or sticker on them.

Vendors

Vendor ID: each vendor associated with the sale of every product from the business will have their own unique identification code to help in identifying and tracking sales through the vendor. This will help identify the most active and efficient vendors.

Contact Information: each and every vendor associated with the sale of the business’ products will have their contact information stored for future reference and delivery purposes.

Internal Store Departments

Departmental ID: Each department within the business will have a unique identification code that will help identify each department and the number of sales each department makes. This will help identify efficient departments and fast moving products to help make informed sales and marketing decisions. The following departments have been found to exist within the business;

  • Fresh Produce Dpt.
  • Food Dpt.
  • Smoothie bar Dpt.
  • Natural Pest Control Dpt.
  • Agrovet Dpt.

References

Harrington, J. L. (2002). Relational database design clearly explained. New York: Morgan Kaufmann Publishers.

Ritchie, C. (2002). Relational database principles. London: Continuum.

Time is precious

Time is precious

don’t waste it!

Get instant essay
writing help!
Get instant essay writing help!
Plagiarism-free guarantee

Plagiarism-free
guarantee

Privacy guarantee

Privacy
guarantee

Secure checkout

Secure
checkout

Money back guarantee

Money back
guarantee

Related Research Paper Samples & Examples

Leadership: Enhancing the Lessons of Experience, Research Paper Example

Abstract Management communication is necessary to ensure the strategic intent of the organization is effectively and efficiently disseminated throughout.  The ability to transfer the information [...]

Pages: 1

Words: 2247

Research Paper

Shifting Parameters of Protection, Research Paper Example

Introduction It is reasonable to argue that the events of September 11, 2001, changed the world radically and immediately, and in ways beyond even the [...]

Pages: 1

Words: 4589

Research Paper

Some Principles of Stratification, Research Paper Example

Introduction The ideas of poverty vary for individual to individual. Social Darwinism theorizes that poverty is based on natural selection. The rich get rich based [...]

Pages: 1

Words: 1936

Research Paper

Cave Paintings and Megalithic Structures, Research Paper Example

One of the things that sets man apart from the other animals is the ability to create art.  It is our art that allows us [...]

Pages: 1

Words: 1096

Research Paper

Ancient Minoan and Assyrian Culture, Research Paper Example

Much can be told about a culture based on their buildings’ architecture and design. Since many ancient people left behind written records that cannot be [...]

Pages: 1

Words: 1672

Research Paper

Greek Influence on Roman Architecture, Research Paper Example

The Romans are famous for their incredible works of art. Roman architecture, sculpture and painting are still considered some of the most beautiful works to [...]

Pages: 1

Words: 2507

Research Paper

Leadership: Enhancing the Lessons of Experience, Research Paper Example

Abstract Management communication is necessary to ensure the strategic intent of the organization is effectively and efficiently disseminated throughout.  The ability to transfer the information [...]

Pages: 1

Words: 2247

Research Paper

Shifting Parameters of Protection, Research Paper Example

Introduction It is reasonable to argue that the events of September 11, 2001, changed the world radically and immediately, and in ways beyond even the [...]

Pages: 1

Words: 4589

Research Paper

Some Principles of Stratification, Research Paper Example

Introduction The ideas of poverty vary for individual to individual. Social Darwinism theorizes that poverty is based on natural selection. The rich get rich based [...]

Pages: 1

Words: 1936

Research Paper

Cave Paintings and Megalithic Structures, Research Paper Example

One of the things that sets man apart from the other animals is the ability to create art.  It is our art that allows us [...]

Pages: 1

Words: 1096

Research Paper

Ancient Minoan and Assyrian Culture, Research Paper Example

Much can be told about a culture based on their buildings’ architecture and design. Since many ancient people left behind written records that cannot be [...]

Pages: 1

Words: 1672

Research Paper

Greek Influence on Roman Architecture, Research Paper Example

The Romans are famous for their incredible works of art. Roman architecture, sculpture and painting are still considered some of the most beautiful works to [...]

Pages: 1

Words: 2507

Research Paper