SQL BUSINESS REPORT

SQL BUSINESS REPORT

SQL Business Report Table of Contents System Summary 3 Anticipated Data 4 Database Management 4 Third-Part Augmenting Software and Enhancements 5 Table Description 5 ERD 7 SQL Queries 7 Data modification and retrieval 9 Application Environment 10 Instructions 11 Lessons Learned 12 The Team A Corporation is the creator of a next-generation software program called Do It All Software. Team A is planning to soon start a user Beta testing program for Do It All Software. The Team A beta test management team is expecting a heavy interest by users to test the program and is preparing a website to assist them. Team A anticipates that the website will be updated several times a day. Team A plans to create a SQL driven Content Management System for the current website that will allow the beta test team members to dynamically update pages on the website and create new pages as needed, without worrying about knowing HTML. System Summary The Content management System (CMS) will be primarily used to manage a beta-testing website for the new software programs. The Team A beta test management team will be creating pages to support the development and beta test of Do It All Software. The main goal is to make it easy for the beta test management team to create, manage, distribution, and publish pages to the website. It will also have the ability to manage the structure of the site, the appearance of the published pages, and basic site navigation provided to the users. Since Team A anticipates a high number of beta testers, powerful hardware and software will need to be utilized. To meet these requirements, the CMS will run on multi-processor Intel based server running Microsoft Windows 2003 Server. The CMS will be developed by in-house engineers using Microsoft SQL Server as…


Comments are closed.