1. Application Prototype For the software application, create a working relational database prototype using SQL Server...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Application Prototype For the software application, create a working relational database prototype using SQL Server and a front-end software. Your prototype should demonstrate your implementation of the work you submitted in the previous phase (make sure you include any changes necessary based on any corrections made to the earlier work). Your application must include >10 records per tables to facilitate testing. You should demonstrate your command of tables, inserting data, writing queries, and creating reports or forms as applicable. For the software application, develop a set of queries (written in SQL Server Management Studio) and reports (developed using the front-end software) to demonstrate the capabilities of your database. UPDATE - Required queries and reports: For the software application, develop a set of queries (written in SQL Server Management Studio) and reports (developed using a front-end software such as Tableau, PowerBI, Access, C++, etc.) to demonstrate the capabilities of your database. Below are 10 reports Rise and Grind has requested to see in a prototype. Choose 7 queries from the list. Write the query for each and develop the reports to display the results in a format that is easy to read and use by Rise and Grind employees. 1. Provide information about each member, the courses they've enrolled in, and how much they paid for each course. Information should include member contact information, membership type information, the course name description, the standard course fee, and the discounted fee paid by the member for enrollment in the course. Enable search by member name. 2. Provide information about each fitness instructor's class schedule, including the instructor's name and id, information about the class itself, the number of members enrolled in each class, the room information, and how many spots are left in the room capacity. Make sure to include information about classes that do not yet have any members enrolled. Enable search by instructor name and the month the class started. 3. Provide a list of supply orders, including contact information for the vendor, the name of the clerk who submitted the order, the order date, the receipt date, the number of days since the order was placed, and whether or not all items were received in full (i.e., quantity ordered matches the qty received). Enable search by vendor and the date the order was placed. 1. Application Prototype For the software application, create a working relational database prototype using SQL Server and a front-end software. Your prototype should demonstrate your implementation of the work you submitted in the previous phase (make sure you include any changes necessary based on any corrections made to the earlier work). Your application must include >10 records per tables to facilitate testing. You should demonstrate your command of tables, inserting data, writing queries, and creating reports or forms as applicable. For the software application, develop a set of queries (written in SQL Server Management Studio) and reports (developed using the front-end software) to demonstrate the capabilities of your database. UPDATE - Required queries and reports: For the software application, develop a set of queries (written in SQL Server Management Studio) and reports (developed using a front-end software such as Tableau, PowerBI, Access, C++, etc.) to demonstrate the capabilities of your database. Below are 10 reports Rise and Grind has requested to see in a prototype. Choose 7 queries from the list. Write the query for each and develop the reports to display the results in a format that is easy to read and use by Rise and Grind employees. 1. Provide information about each member, the courses they've enrolled in, and how much they paid for each course. Information should include member contact information, membership type information, the course name description, the standard course fee, and the discounted fee paid by the member for enrollment in the course. Enable search by member name. 2. Provide information about each fitness instructor's class schedule, including the instructor's name and id, information about the class itself, the number of members enrolled in each class, the room information, and how many spots are left in the room capacity. Make sure to include information about classes that do not yet have any members enrolled. Enable search by instructor name and the month the class started. 3. Provide a list of supply orders, including contact information for the vendor, the name of the clerk who submitted the order, the order date, the receipt date, the number of days since the order was placed, and whether or not all items were received in full (i.e., quantity ordered matches the qty received). Enable search by vendor and the date the order was placed. 1. Application Prototype For the software application, create a working relational database prototype using SQL Server and a front-end software. Your prototype should demonstrate your implementation of the work you submitted in the previous phase (make sure you include any changes necessary based on any corrections made to the earlier work). Your application must include >10 records per tables to facilitate testing. You should demonstrate your command of tables, inserting data, writing queries, and creating reports or forms as applicable. For the software application, develop a set of queries (written in SQL Server Management Studio) and reports (developed using the front-end software) to demonstrate the capabilities of your database. UPDATE - Required queries and reports: For the software application, develop a set of queries (written in SQL Server Management Studio) and reports (developed using a front-end software such as Tableau, PowerBI, Access, C++, etc.) to demonstrate the capabilities of your database. Below are 10 reports Rise and Grind has requested to see in a prototype. Choose 7 queries from the list. Write the query for each and develop the reports to display the results in a format that is easy to read and use by Rise and Grind employees. 1. Provide information about each member, the courses they've enrolled in, and how much they paid for each course. Information should include member contact information, membership type information, the course name description, the standard course fee, and the discounted fee paid by the member for enrollment in the course. Enable search by member name. 2. Provide information about each fitness instructor's class schedule, including the instructor's name and id, information about the class itself, the number of members enrolled in each class, the room information, and how many spots are left in the room capacity. Make sure to include information about classes that do not yet have any members enrolled. Enable search by instructor name and the month the class started. 3. Provide a list of supply orders, including contact information for the vendor, the name of the clerk who submitted the order, the order date, the receipt date, the number of days since the order was placed, and whether or not all items were received in full (i.e., quantity ordered matches the qty received). Enable search by vendor and the date the order was placed. 1. Application Prototype For the software application, create a working relational database prototype using SQL Server and a front-end software. Your prototype should demonstrate your implementation of the work you submitted in the previous phase (make sure you include any changes necessary based on any corrections made to the earlier work). Your application must include >10 records per tables to facilitate testing. You should demonstrate your command of tables, inserting data, writing queries, and creating reports or forms as applicable. For the software application, develop a set of queries (written in SQL Server Management Studio) and reports (developed using the front-end software) to demonstrate the capabilities of your database. UPDATE - Required queries and reports: For the software application, develop a set of queries (written in SQL Server Management Studio) and reports (developed using a front-end software such as Tableau, PowerBI, Access, C++, etc.) to demonstrate the capabilities of your database. Below are 10 reports Rise and Grind has requested to see in a prototype. Choose 7 queries from the list. Write the query for each and develop the reports to display the results in a format that is easy to read and use by Rise and Grind employees. 1. Provide information about each member, the courses they've enrolled in, and how much they paid for each course. Information should include member contact information, membership type information, the course name description, the standard course fee, and the discounted fee paid by the member for enrollment in the course. Enable search by member name. 2. Provide information about each fitness instructor's class schedule, including the instructor's name and id, information about the class itself, the number of members enrolled in each class, the room information, and how many spots are left in the room capacity. Make sure to include information about classes that do not yet have any members enrolled. Enable search by instructor name and the month the class started. 3. Provide a list of supply orders, including contact information for the vendor, the name of the clerk who submitted the order, the order date, the receipt date, the number of days since the order was placed, and whether or not all items were received in full (i.e., quantity ordered matches the qty received). Enable search by vendor and the date the order was placed.
Expert Answer:
Related Book For
Principles Of Information Security
ISBN: 9780357506431
7th Edition
Authors: Michael E. Whitman, Herbert J. Mattord
Posted Date:
Students also viewed these databases questions
-
The following budget estimates have been prepared by Clifton Company: Cash Receipts Cash Payments May $120,000 $150,000 June $110,300 $150,000 The company likes to maintain a minimum cash balance of...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Case Study: Quick Fix Dental Practice Technology requirements Application must be built using Visual Studio 2019 or Visual Studio 2017, professional or enterprise. The community edition is not...
-
Blaine is a practicing dentist. He operates his business from the basement of his house, with a separate entrance and facilities. Blaine uses the simplified method every year to calculate his...
-
Prove Theorem D as follows: Let (a) Show that the series converges for |x| (b) Show that (1 + x)f'(x) = pf(x) and f(0) = 1. (c) Solve this differential equation to get f(x) = (1 + x)p? f(x) = 1 + )-
-
As the manager of the accounts receivable department for Beavis Leather Goods, Ltd., you recently noticed that Kelly Collins, your accounts receivable clerk who is paid $2,500 per month, has been...
-
What information is presented in a statement of retained earnings? What information is presented in a statement of stockholders' equity?
-
Abe is an entrepreneur who likes to be actively involved in his business ventures. He is going to invest $500,000 in a business that he projects will produce a tax loss of approximately $100,000 per...
-
Build and Configure a Static Routing of your Choice in cisco packet tracer please a topology of your choice and submit the following: A Microsoft word document with screen shots showing the following...
-
Guntas Inc. plans an investment with an investment amount of TL 850.000. The cost of liabilities used by the company is 30%, and the risk premium within this rate is 10%. Net cash flows and...
-
Pooler Corporation is working on its direct labor budget for the next two months. Each unit of output requires 0.77 direct labor-hours. The direct labor rate is $10.00 per direct labor-hour. The...
-
Seiko Holdings Plc is based in Birmingham, United Kingdom serving UK and Europe. Seiko Holdings Plc is headed by Clara Chou a seasoned Psychologist who has a strong love for great living spaces...
-
A dentist's chair with a person in it weighs 1875 N. The output plunger of a hydraulic system starts to lift the chair when the dental assistant's foot exerts a force of 33 N on the input piston....
-
The McGregor Company has been in business for more than 20 years. It is a Fortune 500 company that puts most of its investments in overseas markets. Over the past two months, the company has lost...
-
How would you describe Amazon's positioning? Positioning is about how consumers view your brand compared to others. So describe how Amazon is different from its competitors for example Walmart or...
-
Your credit card carries an APR of 22.24% compounded monthly. If your minimum monthly payment is $190 per month, how long will it take you to pay off a balance of $5,000 paying only the minimum...
-
What are the key dimensions of critical thinking 2. Watch the NBC Learn video on Diet Scams. What types of claims are made in this video Are they valid Elaborate on your responses. Discuss this video...
-
Which of the following terms describes the process of making and using codes to secure the transmission of information? a. Algorithm b. Cryptography c. Steganography d. Cryptanalysis
-
Which of the following is NOT a stage as described in NISTs SP 800-34, Rev. 1? a. Determine mission/business process and recovery critically. b. Identify resource requirements. c. Identify recovery...
-
Which of the following is an American contribution to an effort to improve copyright protection internationally? a. Agreement on Trade-Related Aspects of Intellectual Property Rights (TRIPS) b....
-
Advertising is an important type of _________ competition that firms use to _________ the demand for their products.
-
Advertising may not only increase the demand facing a firm, it may also make the demand facing the firm more _________ if it convinces buyers the product is truly different. A more inelastic demand...
-
By making information about substitutes and prices less costly to acquire, advertising will increase the _________ in industries, which is good for consumers.
Study smarter with the SolutionInn App