Software Tool to be used: Microsoft Access
KJ’s Disclaimer about MS Access and it’s Relevance in the workplace:Granted, few organizations use MS Access as it is more of an individual solution tool and easy to navigate BUT…..
MS Access showcases data tables, table relationships and more importantly, the ability to create queries of the data selecting whatever fields and attaching criteria (AND-n-OR) to FILTER or SUMMARIZE massive amounts of data easily
Remember a “Query is a Query” no matter what language it is written in including SQL (Structured Query Language)
Additionally, MS Access allows you to create data entry/inquiry forms and reports too which are NOT required for this assignment.
Instructions
ghadah alshakkakee (name to be used in some data fields that require name)
Step 1: View the assignment Description document with step-by-step instructions:ISAN3380-HW1-BigData-Access Queries.pdf (file below)
Step 2: Download the 2 starter files to your local device/folder (Recommend the Downloads Folder so you remember WHERE you put them)Starter Access Database: Foodmart4g.accdb (file below)
YOUR Answer Sheet: ISAN3380-HW1-LnameFname.docx (file below)
Follow the Assignment Instructions creating the queries, Saving Results as PDF’s and Answering the questions in your answer sheet
Once completed, Save/Close ALL files
Submit all of the required files (or as many as you are able to create) to this Assignment by the due date.
Submit the following 6 files to/for this Assignment HERE:
File 1: HW1-LnameFname-Top10Products.pdf
File 2: HW1-LnameFname-Top10Custs.pdf
File 3: HW1-LnameFname-SalesByStore.pdf
File 4: HW1-LnameFname.docx or doc
File 5: HW1-LnameFname.xlsx
File 6: HW1-Foodmart4g.accdb
Category: Data Entry
I would like to present some information in powerbi that shows department kpi re
I would like to present some information in powerbi that shows department kpi result , department budget uitlization result by using the best charts in powerBI , by linking excel sheet into powerbu
Instructions During this class, students will work on several practice problems.
Instructions
During this class, students will work on several practice problems. Some practice problems require the use of drawing tools and software. These tools are used by IT and business professionals to visualize, analyze, and communicate complex problems, systems, and processes. You need these tools to create Entity-Relationship diagram.
Please refer to the “Course Software” tab on Blackboard to explore the recommended tools. You should use online resources from Youtube and Google to find tutorials and learn how to use these drawing software. Feel free to contact the TA and the instructor if you need further assistance.
Practice Problem 1:
Come up with business rules for the scenarios given below:
Scenario 1: Business rules define two entities and one 1:M relationship.
Scenario 2: Business rules define two entities and one 1:1 relationship.
Scenario 3: Business rules define two entities and one M:N relationship.
For each scenario, clearly identify the following: Business rules that define two entities and describe a relationship in both directions Entities Relationship type Justification of the chosen relationship type (use complete, coherent sentences!)
Practice Problem 2:
Using the business rules provided below, list all the entities, and identify each relationship type among the entities. Business rules are defined as follows:
A painter can paint many paintings. Each painting is painted by only one painter.
A gallery can exhibit many paintings. Each painting is exhibited in only one gallery.
A painter can exhibit paintings at more than one gallery at a time.
Practice Problem 3:
For the business problems given in Practice Problem 2, draw an Entity-Relationship diagram using the Crow’s Foot notation using your preferred ERD drawing tool (check Course Software). Make sure to include all entities, attributes (add 2-3 hypothetical attributes if not given), and relationships.
Assignment Submission
Save all your solutions in a Word file, type your name and course number in that file, name it M1_2_Practice_Problems.
Sample Solution (Attached Document)
Check the attached document for a sample solution that can help you better understand the submission requirements.
Instructions
Throughout this course, you will need to design and implement a real-life relational database for a fictional company. First, you will define the company’s business requirements and design the database schema, showing in detail all the relations (tables), data types, relationships, and constraints to be used in the database. After the design phase is over, you will implement the schema in Oracle by creating the required tables with appropriate data types together with relationships and constraints, and populate all the relations with valid data. Last, you will use your database to retrieve the required data using complex SQL queries.
In this assignment, you need to include the following:
A short description of the company (you can use just one department or business process if the company is large)
Reasons why the company needs a database
Detailed business requirements that describe all entities, relationships, and constraints from the business perspective. Do not include more than 4-5 entities! It is very difficult to design a large database without prior experience. Your database will be revised in the following assignments and you will have a chance to make it more complicated later on.
A detailed description of each entity including the name, purpose, and attributes. Description of relationships between entities. Make sure to evaluate each relationship in both directions!
A list of different users for the database you proposed. Define user categories and describe different types of applications each user would need. Explain what type of interface each user would need.
Explain which DBMS architecture would you choose from section 2.5 of the Fundamentals of Database Systems textbook and why. Why would the other architectures not be a good choice?
Assignment Submission
Write your solutions in a Word file, type your name and course number in that file, name it M1_2_ Relational_Database_Specifications. Your paper will be checked in SafeAssign for originality.
i need help separating city’s and zipcodes in excel. EXAMPLE: if there is a city
i need help separating city’s and zipcodes in excel.
EXAMPLE: if there is a city that is 30 minuets from downtown i want it to tell me, and to separtae them by major cities.
I have attached a screenshot of the rubric, a PDF for of an example of what I ne
I have attached a screenshot of the rubric, a PDF for of an example of what I need done similar to the assignment, and lastly the assignment instructions with a word document. Also for things I do on my schedule you put things like the gym, play basketball, work, Logistics class online in the morning, Get groceries,
ScenarioThe most important thing to your friend is a cost breakdown; they need t
ScenarioThe most important thing to your friend is a cost breakdown; they need to know how much they will spend on everything to plan ahead. When presenting the vacation information to your friend, you will also provide an estimated budget for the trip so your friend will have the total cost and the specific expenditures. InstructionsUsing Microsoft Excel, create a vacation budget that includes the following:
Transportation cost (plane or train ticket or estimated gas price based on mileage)
Lodging cost
Estimated costs for food and activities
Include any other costs identified during research
You can use a budget template in Excel or create your own, but the document must:
Utilize headers to show organized information
Utilize formulas, including the SUM formula to show the total cost of the trip
Include a chart of the cost categories
Be organized and readable
Objectives Analyze data using numerical, graphical displays, and other statistic
Objectives
Analyze data using numerical, graphical displays, and other statistical analysis.
Use Excel or another statistical software package to analyze data.
Report the results and conclusions in a statistically sound manner.
Submit two document one for the analysis requirement and one for the submission deliverable. The analysis should be a word document and submission deliverable should be in power point and you can leave out the “introduction of the group part”.
For the power point “the result” slides must include all four questions and histogram or graph as support document
State: Florida
please follow all the steps, I am attaching everything you need, I have also att
please follow all the steps, I am attaching everything you need, I have also attached my first assignment after which you must work. Your work is a continuation of the first assignment. You must to do also this appendix
Objectives Analyze data using numerical, graphical displays, and other statistic
Objectives
Analyze data using numerical, graphical displays, and other statistical analysis.
Use Excel or another statistical software package to analyze data.
Report the results and conclusions in a statistically sound manner.
Submit two document one for the analysis requirement and one for the submission deliverable. The analysis should be a word document and submission deliverable should be in power point and you can leave out the “introduction of the group part”.
For the power point “the result” slides must include all four questions and histogram or graph as support document
State: Florida
Completed tables for final project This week you are submitting your completed f
Completed tables for final project
This week you are submitting your completed final project tables!
These include:
Table 1 (required): Description of the study sample with stratification by levels of exposure variable
Table 2 (required): Results from your primary analysis
Figure (optional): A graph visualizing some aspect of your data analysis
Use the feedback you received from Assignment 4 to structure your tables.
The specific structure will vary depending on the research question you choose.