Fluent Essays

Please see attached fileSQL (4 pages) I tried to do this assignment but I didn’t pass – here is the professor feedback “Can you please submit all the scripts? I only see few tables created by you. Please create all the required tables and complete all the queries and then resubmit your work” I will also attach my project so you can pick it up from there. Problem-Based Learning Scenario A retail store wants to offer its products online in response to numerous customers requesting to be able to purchase the company’s products electronically. The company is beginning to see some growth in spite of the recent economic downturn. The company strives to meet the needs of its customers, including giving them the perception that they are the company’s highest priority. Being a profitable operation has not always been the case, and the company has historically struggled with customer service issues, inventory-management problems, employee turnover, and poor productivity overall. Naturally, the stakeholders of the company began to lose faith in the viability of the company, and unfortunately, numerous stakeholders have dissolved their relationship with the retail store entirely. Approximately 7 years ago, the company hired a freelance information technology (IT) organization to create a data-driven information system that would support customer records and order entry. The store manager convinced the owner of the company that this route was the way to go. After all, anything would be an improvement over what the company had at the time. The owner felt that because it was important to have an efficient way to track customers and orders, any computerized system would be sufficient. He was not too proud to share his lack of technological skills, and often deferred to others when it came to making decisions in this area. He often joked that perhaps some computer training would do him and his employees some good. He was never really assured that his data were backed up correctly or that his system was secure. And what if the system crashed or the data started to appear unusual? He also had never heard of any of his employees backing up the system files. If he lost all of his data, he would not know where to turn or what to do. The very idea of his business depending so much on technology was almost too stressful to think about. Deep down, however, he really wanted some assurance that his information was reliable and secure. The customer records and order entry system that was installed solved a few problems for the short term but quickly proved to lack the capability to meet the goals, objectives, and overall data needs of the company. The freelance technology company provided no documentation on how to use the system or even how it was designed. A large component that was missing was having the ability to track the product inventory. The system in its current state does not seem to be fully functional and often lets employees override the store procedures that the owner hDatabase Administration Plan (4 pages) Problem-Based Learning Scenario A retail store wants to offer its products online in response to numerous customers requesting to be able to purchase the company’s products electronically. The company is beginning to see some growth in spite of the recent economic downturn. The company strives to meet the needs of its customers, including giving them the perception that they are the company’s highest priority. Being a profitable operation has not always been the case, and the company has historically struggled with customer service issues, inventory-management problems, employee turnover, and poor productivity overall. Naturally, the stakeholders of the company began to lose faith in the viability of the company, and unfortunately, numerous stakeholders have dissolved their relationship with the retail store entirely. Approximately 7 years ago, the company hired a freelance information technology (IT) organization to create a data-driven information system that would support customer records and order entry. The store manager convinced the owner of the company that this route was the way to go. After all, anything would be an improvement over what the company had at the time. The owner felt that because it was important to have an efficient way to track customers and orders, any computerized system would be sufficient. He was not too proud to share his lack of technological skills, and often deferred to others when it came to making decisions in this area. He often joked that perhaps some computer training would do him and his employees some good. He was never really assured that his data were backed up correctly or that his system was secure. And what if the system crashed or the data started to appear unusual? He also had never heard of any of his employees backing up the system files. If he lost all of his data, he would not know where to turn or what to do. The very idea of his business depending so much on technology was almost too stressful to think about. Deep down, however, he really wanted some assurance that his information was reliable and secure. The customer records and order entry system that was installed solved a few problems for the short term but quickly proved to lack the capability to meet the goals, objectives, and overall data needs of the company. The freelance technology company provided no documentation on how to use the system or even how it was designed. A large component that was missing was having the ability to track the product inventory. The system in its current state does not seem to be fully functional and often lets employees override the store procedures that the owner has clearly stated should be adhered to. For example, customers are given discounts when they are not eligible, certain products are completely depleted from inventory without being flagged for reorder, and prospects who have never placed an order are set up as customers with a fake order to give them fRunning head: DATABASE 1 DATABASE 22 Database System Development and Implementation Plan Enterprise Data Management IP3 Table of Contents 3 Database System Overview 3 Description of General Business Environment 4 Database System Goals and Objectives 5 Addressing the Problems through the Database System 6 Alignment with Organization’s Goals and Mission Statement 7 How this Part of the Project Fulfills the Mission and Goals of the Organization 8 Entity Relationship Model (TBD) Subjects of Interest……………………………………………………………………………….….…... 8 Business Rules……………………………………………………………………………………….….… 9 Entity-Relationship Model ……………………………………………………………………………….9 Fulfilling the mission and goals of the case study organization………..………………………… 12 Structured Query Language (SQL) Scripts (TBD) 13 Structured Query Language (SQL) statement scripts needed to create the database schema for the relational database system……………………………………………………………………………13 How Scripts Support Goals and Objectives of the Company…………………………...…………17 Database Administration Plan (TBD) 19 Future Database System Implementation Plan (TBD) 20 References 21 Database System Overview At a time when information technology is integrated into every process of business management, it is only prudent to ensure that the chosen technology works properly and helps an organization to meets its strategic goals and objectives. Consumers have become increasingly aware of their value and want nothing but the best services. They also need convenience when they show for products. This explains why online shopping has become a significant trend today. In order for organizations to be able to offer their products online and to make sure that there is efficiency in the process, a proper database system needs to be developed. Online purchases mean high volume of information which have to be collected, maintained and modified. There is need to ensure that the database system has no errors. There should be consistence, accuracy and integrity when both customers and employees interact with the system. This will guarantee satisfaction on the part of customers as well as other stakeholders like employees and investors. This part of the database system development and implementation plan shall provide an overview of the database system. This shall be based on a scenario that shall be briefly presented while describing the general business environment of the selected store. The goals and objectives of the system shall be described and information on how the system shall address the presented problem shall be provided. Finally, this part shall be concluded by discussing