Module 5 Homework Assignment (1)

- The Evaluation table shown in the ERD diagram does not connect to any table. Identify the problem of this table and explain how you could connect this table to the other tables? - Which attribute in the Evaluation table should not be entered by the user manually to eliminate data entry error? Name and explain the solution that you will be used to fill in the value for that attribute?

Garden Glory is a partnership that provides gardening and yard maintenance services to individuals and organizations. Garden Glory is owned by two partners. They employ two office administrators and a number of full- and part-time gardeners. Garden Glory will provide one-time garden services, but it specializes in ongoing service and maintenance. Many of its customers have multiple buildings, apartments, and rental houses that require gardening and lawn maintenance services.   Create a sample list of owners and properties. Your list will be similar in structure to that in Figure 1-34 g, but it will concern owners and properties rather than owners and pets. Your list should include, at a minimum, owner name, phone, and billing address, as well as property name, type, and address. B. Describe modification problems that are likely to occur if Garden Glory attempts to maintain the list in a spreadsheet. C. Split the list into tables such that each has only one theme. Create appropriate…

To vary your reporting, you decided to include graphical representation.  Create a clustered column chart that shows the total amount each active customer with a data plan must pay.  Format the total pay column to currency and give the chart an appropriate title.  Remember to label the axes.  (Hint: Create a query and export it to a spreadsheet application to create the chart.) Ensure that the chart is labelled appropriately and is placed on a new sheet. Name the Spreadsheet as MGMT2006_G#_<first name last name>. For example, MGMT2006_G50_ Jane Doe.

Instructions: Create a dimensional model for a particular business process involving gym membership. A customer can sign up for a membership of say one, three, six or twelve months. I want to make it easy to query to identify current members, members who expired in the last month, members who renewed in the last month, those who are pending expiry etc. If I have a basic model with a fact table representing a gym membership say start_date_key end_date_key membership_attribute_key customer_atrribute_key fee with associated dimension table for date, membership attributes such as length, customer attributes and so forth. On a particular day, the active members are those with a start date before the day and an end date after that day. Those who will expire next month are those where the end date is in a particular date range.

The Car Maintenance team wants to learn how many times each car is used in every month and day to organize their maintenance schedules. The team wants a table with the following column names and information:•Car ID•Month•Day•CountYou need to create a summary table using the WITH ROLLUP modifier and grouped by the specific column names, listed above, and send the data back to the team.

Question 04: Draw horizontal portioning of student portal (any of 3 functionalities)

Question 7 Integration features/commands can be used to create a chart from access data. True False

Please written by computer source Please help me with this It's from MB-500 renewal   Question 19 of 25 A company uses Dynamics 365 Supply Chain Management. The company is configuring dual-write for implementation. You need to access the out-of-the-box data entity mappings in Dynamics 365 Supply Chain Management. Which three actions must you complete first? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. Select all answers that apply. 1.complete the health check 2.create the Microsoft Dataverse environment 3.select the legal entities to integrate 4.run the initial sync process 5.enable the dual-write application   Question 20 of 25 You are a Dynamics 365 Finance technical lead creating a value proposition presentation for using the dual-write solution. You need to identify key concepts in dual-write that add value. Which two concepts should you identify? Each correct answer presents part of the solution. NOTE: Each correct selection…

3. The QR table records the workshop attendance of students. The BB table is a master table that holds student’s data in INFO151. The ZOOM table automatically records students who enter the workshop session with zoom. The requirements for each of the tables are listed in the requirement table below. (a) Write the DDL to create the tables with the suggested attributes, data types and constraints.  (b) What is a composite key? Is the primary key in the BB table a composite key or a surrogate key? Must the last name be unique for this type of primary key? (c) Discuss the limitation of using FName and LName as the primary key. (d) Is the relationship between BB and QR tables a one-to-one? If it is not, state the correct relationship.

Query design by referring the following scenario.Scenariocompany has a huge database to handle their employees’ details.Most of the details regarding the employee activities and department details are stored in Employeestable and Departments table. Write the appropriate query to support the manager to complete thefollowing: