Skip to main content

How could a well-managed database help the company better achieve its goals?

 D1: DB Project Analysis & Query: Develop a reasonable and realistic plan and outline the steps to accomplish the integrated project by the end of the course. You can also refer to Garden Glory project questions in §1~3 of the Textbook (at the end of each chapter).  

  1. How could a well-managed database help the company better achieve its goals?

v   Hint: refer to Text Chapter 1 for " Advantages of database approach " and apply that understanding to the GG project case

  1. What are the modification problems that are likely to occur if Garden Glory attempts to maintain the list below in a spreadsheet?

v   Hint: refer to Text Chapter 1 for " Modification Problems " and apply that understanding to the GG project case

  1. Using these data presented in the list, state assumptions about functional dependencies among the columns of data. Justify your assumptions on the basis of these sample data and also on the basis of what you know about service businesses. Indicate what assumptions need to be checked with the users (GG) and what suggestions you may have about the determinants/keys (e.g., do you need a surrogate key?)

v   Hint: refer to Text Chapter 2 for " Functional Dependency " and apply that technique to the GG project case

  1. Based on the above analysis and assumptions, split the sample list into tables such that each has only one theme. Demonstrate that the modification problems you identified in question 2 have been eliminated.

v   Hint: refer to Text Chapter 2 for " Normalization Process " and apply that technique to the GG project case. You can also refer to the 9 possible designs provided in the GG Project Questions section at the end of Chapter 2 in Text book, on pp.129-130, and choose the best one you believe.

5.   Assume that based on your suggestions and their additional requirements, Garden Glory designs a trail database saved as Garden_Glory.accdb in MS Access. Query the trail database using SQL statements and answer the following questions. For each SQL statement you write, show the results based on your data (you could press the "PrtSc - Print Screen" key to capture the results image) .

v   Hint: refer to Text Chapter 3 for " SQL Queries " and apply that knowledge to the GG project case.

5.1)   Write SQL statements to list all columns for all tables.

5.2)   Write an SQL statement to list the LastName , FirstName and CellPhone for all employees having an experience level of Master .

5.3)   Write an SQL statement to list the LastName , FirstName and CellPhone for all employees having an experience level of Master and a FirstName that begins with the letter J .

5.4)   Write an SQL statement to list the Name of employees who have worked on a property in New York .

5.5)   Write an SQL statement to list the names of employees who have worked on a property owned by a Corporation .

5.6)   Write an SQL statement to show the name and sum of HoursWorked for each employee.

5.7)   Write an SQL statement to show the sum of HoursWorked for each ExperienceLevel of EMPLOYEE.  Sort the results by ExperienceLevel in descending order.

5.8)   Write an SQL statement to show the sum of HoursWorked for each Type of OWNER but exclude services of employees who have an ExperienceLevel of Junior and exclude any Type with less than three members. 

Garden Glory Project" style="float: left;">Previous Garden_Glory Trial Database (For D1 SQL query testing use)" style="float: right;">Next

GET SOLUTION FOR THIS ASSIGNMENT

CLICK HERE TO MAKE YOUR ORDER

TO BE RE-WRITTEN FROM THE SCRATCH

NO PLAGIARISM

Green Order Now Button PNG Image | Transparent PNG Free Download on SeekPNG Our Zero Plagiarism Policy | New Essays

Comments

Post a Comment

Popular posts from this blog

Should pit bull terriers be banned in my community

 Discussion Forum: Counterarguments (Should pit bull terriers be banned in my community) You created a question about the topic for your W6 Rough Draft. For this discussion, you will give an answer to that question in the form of a thesis statement. "Dieting Makes People Fat" Main Post: Share your thesis statement with your classmates. Please note: As with last week’s discussion, nothing here is set in stone. Be open to changing everything about your topic, including your position and audience, as you research it and get feedback from your classmates. Topic + Position/Purpose + Supporting Points =Thesis Statement Example: Suppose the question you posed in the Week 5 discussion was something like, “Should pit bull terriers be banned in my community?” After doing some preliminary research, you have concluded that pit bulls, if raised properly, are no more dangerous than other breeds of dogs. Your thesis statement can be something like, “Pitbulls should not be banned
Post a Comment
Read more

CYBER SECURITY and how it can impact today's healthcare system and the future

 Start by reading and following these instructions: Create your Assignment submission and be sure to cite your sources, use APA style as required, and check your spelling. Assignment: Recommendations Document Due Week 6 (100 pts) Main Assignment Recommendations Document The 1250 to 1500-word deliverable for this week is an initial draft of your recommendations. Note that this is a working document and may be modified based on insights gained in module eight and your professor's feedback. This document should contain the following elements: Summary of your problem or opportunity definition A list of possible recommendation alternatives. In this section, you are not yet at the point of suggesting the best set of recommendations but you are trying to be creative and explore all the different ways that the problem or opportunity might best be addressed. The end result here will be a list of alternatives among which you will choose your final recom
Post a Comment
Read more

Do violent video games encourage players to become violent in real life?

 Write an outline for Speech 3, the persuasive belief speech, following the outline guidelines and formatting requirements (Do violent video games encourage players to become violent in real life?).  1000-1200 WORDS https://virtualspeech.com/blog/persuasive-speech-outline-structure-delivery Topics: https://blog.prepscholar.com/good-persuasive-speech-topics Do violent video games encourage players to become violent in real life? https://www.youtube.com/watch?v=YKKWOx43pIY WE HAVE DONE THIS ASSIGNMENT BEFORE, WE CAN ALSO DO IT FOR YOU GET SOLUTION FOR THIS ASSIGNMENT,  Get Impressive Scores in Your Class CLICK HERE TO MAKE YOUR ORDER   on Do violent video games encourage players to become violent in real life? Are You looking for Assignment and Homework Writing help?  We Provide High-Quality Academic Papers at Affordable Rates. No Plagiarism. TO BE RE-WRITTEN FROM THE SCRATCH
Post a Comment
Read more