Unit 1-Database System Overview (Week 1 IP), Assignments of Database Management Systems (DBMS)

Download Unit 1-Database System Overview (Week 1 IP) and more Assignments Database Management Systems (DBMS) in PDF only on Docsity!

Running Head:Unit 1-Database System Overview (Week 1 IP) Database Systems (CS660-2301A-01) Unit 1 IP Week 1 IP: Database System Overview Student Name 22 nd^ Jan, 2023

Table of Contents

• I. Database System Overview (Week 1 IP)...............................................................................................
  • a) Description of the Organization...........................................................................................................
  • b) Database system goals and objectives Statement...............................................................................
  • c) Measure of how the proposed system aligns to the mission statement and goals.............................
• II. Entity Relationship Model (Week 2 IP)..............................................................................................
• III. Structured Query Language (SQL) Scripts (Week 3 IP).................................................................
• IV. Database Administration Plan (Week 4 IP)......................................................................................
• V. Future Database System Implementation Plan (Week 5 IP)...........................................................
• References................................................................................................................................................

one-stop shopping experience for community members who are seeking to eat healthier, learn about and engage in sustainable lifestyle practices. The goals that the database ought to help Luna’s Health food achieve includes the objectivity of increasing the retail store’s customer base by a proposed 20%. This is so critical to the survival of the retail store in that it also mens that Luna’s business patner will remain in the business and not pull their finaces from the business that migt be detrimental to the business. The database also ought to help in the expansion of the product category offerings. This will go a long way in achieving the much needed convenience by customers from the business’ website. All the information on product availability, recipes and prices will be available on the website. This will increase the retail store’s competitiveness against other big food retail companies around. This will also help in increasing the customer base of the company and eventually achieving the needed sales target set by the business partners. The other goal that the database is supposed to help achieve is to help in the making of product, health and recipe information available to customers. This help the retail store remain in competition against the other big companies that are gunning for its customers. A visit to Luna’s Health Food’s website ought not just give information about the food available but also better recipes and natural homeopathic remedies as added incentives to using the store’s website. This will go a long way in making sure busy users will just use the store’s website as a one-stop for their grocery shopping. This move will also go a long way in helping the business achieve another goal of increasing the overall store’s sale by 8%. This is one of the incentives that Luna has to achieve in order to ensure the longevity of his business. This can only be achieved by the store’s ability to attract new customers and be able to fully satisfy and maintain its existing customers. The new website’s main objectives to be able to help the business achieve its goals.

A database system is ideally a software that caters to the collection of electric and digital records to extract useful information and store that information (Syeda 2021). The main purpose of a database system is for storage and retrieval of information (Syeda 2021). The data stored in a database sytem can then be easily accessed, managed, modified, updated, controlled and organized (Ming 2003). The existing database currently in use by Luna’s store does not possess the capacity to relay all the intended information that Luna wants it to show to his customers and also it does not relay all the information needed by the customers especially the busy ones. These challenge can lead to the store losing its customers to other big companies who are able to show the customers whatever they need to know. By counteracting this threat, the store is able to stay in business and also due to the nature of the product they offer, increase its sales and most importantly while ammersing new customers they are able to hold on to their current ones. A database is seen as importantly as a source of information (Ming 2003) and in this case, Luna’s Organic Food Store’s website’s database should be able to correctly and articulately relay whichever information Luna wants the customer to know about his store. The challenges that Luna is currently facing can be solved by this new proposed system by first of all making it possible for the system to be able to print out the recipes and the other literature he wants to offer to the public. To help with the set goal of expanding his product category offerings, the system could be able to conduct a customer survey to evaluate how satisfied they are with the current array of products in offer and what they would like to be added to the list in future in terms of new products or improved quality of existing products. This will give Luna the capacity to see the trends in terms of customer taste and also be able to change with it. This helps the store achieve customer satisfaction which is critical to its survival. c) Measure of how the proposed system aligns to the mission statement and goals. The proposed system will have a number of databases within the main system. These databases will include customers database, product categories database, recipes database, articles database, workshops

II. Entity Relationship Model (Week 2 IP).

III. Structured Query Language (SQL) Scripts (Week 3 IP).

V. Future Database System Implementation Plan (Week 5 IP).

References Syeda Famita Amber (2021). Database Systems: A simplified Analysis 101. https://hevodata.com/learn/database-systems/#:~:text=Database%20Systems%20or %20DBMS%20is,to%20store%20and%20retrieve%20data. Ming Wang, Russell K. Chan (2003). History of Database Development. Encyclopedia of Information Systems.