1-Scenario: Think of an opportunity in your personal, academic, or professional life in which you could use a database (ordering supplies, tracking inventory, maintaining a customer mailing list, organizing a library, etc.). Answer the following questions: What guidelines would you use for designing your database and tables? Who would your end users be and how would you accommodate their needs through your design? Explain how you would use filters or queries. What’s the difference between a filter and a query? What kinds of reports would you run? Why? 2-Scenario: You’ve been asked to give a 10-minute PowerPoint presentation in one of your classes, at work or for a family/friends occasion (you choose which class, work or family/friends occasion). Answer the following questions: What will you do before you begin to work on the PowerPoint presentation? How will you organize your materials? Why? What is the topic of your presentation? Who is your audience? How will you create a presentation that is appropriate for your audience? How do you know how many slides to add for a 10-minute presentation? PowerPoint has four different views. Explain how you may use each of the views while you are developing your presentation. Purchase the answer to view it

1- When designing a database and tables for an opportunity in my personal, academic, or professional life, there are several guidelines that I would follow. Firstly, I would ensure that the design is in line with the specific needs and requirements of the opportunity. This would involve identifying the key data elements that need to be stored and organizing them in a logical and efficient manner.

To begin with, I would define the primary keys for each table in the database to ensure data integrity and uniqueness. This would involve choosing a unique identifier for each record in the table. For example, in an inventory tracking system, the primary key for the “products” table could be a unique product code.

Next, I would determine the relationships between the tables. This would involve establishing the various associations and dependencies between the different data entities. For instance, in a customer management database, there could be a relationship between the “customers” table and the “orders” table, where each customer can have multiple orders.

Additionally, I would consider the data types and constraints for each attribute in the tables. This would involve selecting the appropriate data type for each column based on the nature of the data it will store (e.g., text, number, date, etc.). Constraints, such as data validation rules, limits on field lengths, and referential integrity rules, would also be defined to ensure data consistency and accuracy.

In terms of end users, it would be important to identify who will be using the database and how they would interact with it. For example, in an inventory management scenario, end users could be employees responsible for placing orders and tracking inventory levels. To accommodate their needs, the database design should provide a user-friendly interface and intuitive navigation. This could involve creating forms, reports, and queries that allow users to easily input and retrieve data.

Filters and queries are important tools for retrieving specific information from a database. A filter is used to isolate and display a subset of records that meet certain criteria. For example, in a customer mailing list database, a filter could be applied to display only customers who have made a purchase within the last six months. On the other hand, a query is a more advanced tool that allows for complex searches and data manipulation. It can be used to perform calculations, combine data from multiple tables, and generate custom reports.

In terms of reports, the choice would depend on the specific needs of the opportunity. Common types of reports could include summary reports, which provide a concise overview of data, and detailed reports, which present a comprehensive view of specific records. For instance, in an inventory tracking system, reports could be generated to show current stock levels, sales trends, and order history. The reports would assist in decision-making processes, identify areas for improvement, and monitor overall performance.

Overall, an effective database design should be tailored to the specific needs of the opportunity, accommodate the requirements of end users, and make use of filters, queries, and reports to provide valuable insights and information.

2-

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Click Here to Make an Order Click Here to Hire a Writer