Description: Select a company and focus on a business process of your choice (e.g. particular operation within the company — small or big), either from a real or imaginary business. Suggest a database solution that enhances the process and helps the business to gain a strategic competitive advantage. Design database tables with fields related to the selected business process. The main purpose is to demonstrate the value of designing and using Databases for gaining competitive advantages. Guidelines: 1: Database shall include only 3 relational tables 2: Each table shall include at least 5 fields having different types (Numeric, Text, and Date) 3: Tables shall be linked through their Primary/foreign keys 4: Report shall include at least 500 words written using MS-Word, and include the following sections: A. Description of the business (100 words) B. Business process of interest and the planned improvement (200 words) C. Strategic competitive advantage of the Database (200 words) D. A complete ERD Diagram showing the basic structure of the Database with description.
Sample Solution
