Assignment 1 True/False Questions: Database Development

Great Essays
Register to read the introduction… Assignment Requirements
Answer the true-or-false questions on the next page by filling out the answer sheet.

Required Resources
Textbook

Submission Requirements
Submit your completed answer sheet to your instructor at the beginning of Unit 8.

Unit 7 True/False Questions
Indicate whether the following statements are true or false on the student answer sheet. 1) A scalar function operates on one row at a time. 2) An aggregate function works on multiple rows a time. 3) Whenever you have an aggregate function in a query criteria, you must use the HAVING keyword. 4) Any column in a SELECT that contains an aggregate function, but that is not a part of the aggregate function, must be addressed in a GROUP BY clause. 5) An inner join returns all the records in the joined tables. 6) There is no error of the following SQL statement:
SELECT CustomerCity, Count (CustomerKey)
FROM Customer 7) There is no error of the following SQL statement:
SELECT CustomerCity, Count (CustomerKey)
FROM Customer
GROUP BY CustomerCity
WHERE Count(CustomerCity) > 20 8) The following SQL statement would change every customers' last name to
…show more content…
57–64)

Project Logistics
You will begin and complete this project during your Unit 10 lab time. The steps for completing this project are provided in your Lab Manual for Database Concepts, starting on page 51 with a refresher of the critical concepts for review and continuing through page 64 with the final submission.

Prepare for this project by reviewing the prior units’ lab assignments and the prior units’ material covering the course objectives and learning outcomes.

Deliverables
You will submit an MS Word document with the answers to the three questions integrated within the project at key points. Questions 1 and 2 are on p. 62 and Question 3 is on p. 63 of the lab manual. This MS Word document will be named nn_Projectanswers.doc, where “nn” is changed to your initials.
You also will submit eight screen shots of specific steps within the project, along with your MS Word document described above. These screen shots should each be a separate file. Include your initials at the beginning of the file name for each screen shot. Details of naming your screen shots are provided within that specific step of the project, Project_#, and the screen shots will be taken at the following

Related Documents

  • Great Essays

    (TCO C) A project to remodel an office area has the following activities. (Hint: You will need to build an AIB diagram, perform a forward pass, and perform a backward pass to answer this question.) ............... a) What are the critical path activities? (5 points) b) What is the project's scheduled completion time?…

    • 961 Words
    • 4 Pages
    Great Essays
  • Improved Essays

    Information Management Introduction Over the year, I have completed 5 DT internal assessments. These included AS 1.41, AS 1.43, AS 1.45, AS 1.46, and AS 1.50. In completing these assessments, I have became more familiar with the applications that were used to complete these internal assessments, and has given me a better understanding for file structure. Assessments Completed AS 1.43 - First assignment: Website.…

    • 1963 Words
    • 8 Pages
    Improved Essays
  • Improved Essays

    US Honors Pre-WWI

    • 1380 Words
    • 6 Pages

    U.S. Honors Pre-WWI Name: Yash Parikh_________________ Score: ______ Read Chapter 8. Do further research on databases and books. Your textbook is a resource but cannot be used as a cited source. You must have a Works Cited page. 1.…

    • 1380 Words
    • 6 Pages
    Improved Essays
  • Decent Essays

    Unit 10 D2

    • 502 Words
    • 3 Pages

    Task 10 (D1) Discuss how potential errors in the design and construction of a database can be avoided. One of the potential errors that can occur when creating a database is that field names and names can be spelt incorrectly due to human error this can be difficult to spot if the database is big the way of making sure that there are no naming errors is to make sure that every is checked regularly and more than twice to make sure that the chances of finding a spelling mistake is reduced. Using the wrong data type is another potential error that can occur when creating a database this can be troublesome as if there is a relationship created between the tables and the mistake is found and changed then the database wouldn’t allow you to change the field where the data type is incorrect without removing the relationship first so it will be made into a long process of removing the relationship between the tables changing the data types for each of the table before remaking the relationship between the tables again the way of preventing this is by looking at the field names for the database and then choosing the correct data type also perhaps getting the opinion of another person and rechecking that they are all correct before creating the relationship.…

    • 502 Words
    • 3 Pages
    Decent Essays
  • Great Essays

    Nt1330 Unit 2 Case Analysis

    • 2280 Words
    • 10 Pages

    Question 3 a. In designing the user interface for the sales prospect and contact management system, Kevin made the following errors: • Kevin did not fully understand the business functions; create a Functional Decomposition diagram (FDD) that would have helped him identify the business functions. • Kevin should have created a model / prototype and presented it to users for approval; if he would have done this, he could have received feedback from the users. • Kevin designed the user interface that was not user friendly, easy to use or provide enough help screens to assist users, and make help easy to find. • Kevin should have designed fields that allow users to select information or check box, thereby eliminating the need users to type data into…

    • 2280 Words
    • 10 Pages
    Great Essays
  • Improved Essays

    LS Assignment

    • 825 Words
    • 4 Pages

    LS.1.1.1 Living things require energy, water and a particular range of temperature in their environments. List the long-term scoring guideline that will give evidence that your students have mastered the standard (s); The overall scoring guideline will include students understanding animals are living this that grow and change and can be classified as mammals, birds, fish, amphibians, reptiles, or insects by the end of the unit. More specifically, students will learn long-term objectives related to the standard. LS.1.1.1 Living things require energy, water and a particular range of temperature in their environments.…

    • 825 Words
    • 4 Pages
    Improved Essays
  • Improved Essays

    Rttls Assignment 3.3

    • 337 Words
    • 2 Pages

    3.3 Procedure Prior to the first week, teachers and students will be informed about the details of the programme. Students will be told that they need to attend a 2-hour writing class every week. In the lesson, they will be asked to do some authentic writing tasks and it is about everyday life. Each participant has to write four essays during the 10 weeks’ semester, staged at weeks 2, 4, 7, 9. All the essays will be collected right after the lesson as a reference.…

    • 337 Words
    • 2 Pages
    Improved Essays
  • Improved Essays

    On September 21, 2015, Ms. Sophia Martinez approved the topic of researching and addressing the problem of mandating the purchase of an overpriced dining plan provided by Texas A&M University (TAMU) to students living on campus. To be in accordance with the dining services on campus, there are numerous innovative selections to accommodate the availability of dining options for students living on campus. Some of these options are in five different type of blocks ranging from 90 to 240 meal trades and about 300 to 500 dining dollars per semester. The price of dining options can range from $1,300 to $2,100 per semester not including tax.…

    • 844 Words
    • 4 Pages
    Improved Essays
  • Great Essays

    Australia’s aging population amplifies the fact that protective legislation for the elderly must be introduced. Question 7: Refer to both the Consent to Medical Treatment and Palliative Care Act 1995 (SA) and the AHPRA Code of Conduct to explain why medical practitioners and others are obliged to explain to patients/clients the consequences of proposed treatments. Medical practitioners and other health care professionals are obligated to explain to patients/clients the consequences of proposed treatments in order to enable them to make an informed decision and made aware of any material risks that are associated with any part of the proposed management plan (Code, section 3.3(d)(e)(g), page 10) (CMT&PCA (s15)). Question 8: ‘There is no…

    • 1546 Words
    • 7 Pages
    Great Essays
  • Great Essays

    Independent Study Proposal

    • 1573 Words
    • 7 Pages

    Introduction This report explores the benefits of a Kent Denver sponsored Independent Study Program and finds that a flexible and informal program is pragmatic, easy to implement and enhances the excellence of the Kent Denver academic experience for willing students. Part II outlines the first draft of the plan and includes explicit procedures for the continuation of the research program, which will run for the most part, independent of interference from the Kent Administration and Faculty. Consequently student research will be autonomous and teacher involvement in research will be minimal. Part III addresses the current obstacles and arguments against such a program, such as the Global Online Academy, teacher workload, and consistent student…

    • 1573 Words
    • 7 Pages
    Great Essays
  • Improved Essays

    Practical Title: The pros and cons of cell signalling experiments: risk assessments Aims: The aim of this experiment was to identify the risks associated with working in a laboratory by carrying out a risk assessment. The risk assessment instructed us how to safely work in a laboratory while being aware of these risks and what procedures to carry out if an accident happened in the laboratory. Methodology: Prior to the beginning of the risk assessment, laboratory coats, nitrile rubber gloves and labortartory goggles were worn to protect and shield from the dangerous chemicals that would be encountered during the assessment.…

    • 1596 Words
    • 7 Pages
    Improved Essays
  • Improved Essays

    Task 1 1.1 Explain the importance of project management principals, and explain how it would support to bring solution for the above scenario (1.1) (M2.1) What is a Project? There are several definitions of projects in the literature, one of the best has been given below by Tuman. “A project is an organization of people dedicated to a specific purpose.…

    • 778 Words
    • 4 Pages
    Improved Essays
  • Improved Essays

    DESIGN A decision has been reached by individual(s) with responsibility to effect change in order for an organisation to remain competitive and flourish. Plan. In order to start the process a proposal (business case) needs to be produced. This would identify the issues that need to be addressed, cost implications, who should be directly involved with the project and the potential outcome and benefits.…

    • 737 Words
    • 3 Pages
    Improved Essays
  • Great Essays

    The project ‘SAP Finance: Blogging’ was conducted for Deloitte Consulting USI Pvt. Ltd., a subsidiary of Deloitte Touche Tohmatsu. SAP Package Technologies, one of the verticals, required an employee friendly platform to share and upgrade knowledge on SAP Finance. The project required me to develop and document communication platform for the SAP FICO team to exchange news & developments in SAP Finance.…

    • 3063 Words
    • 13 Pages
    Great Essays
  • Improved Essays

    1. In Oracle, when is it better to use materialized views? A. It is always better to use materialized views because views are obsolete and materialized views replace them B. When a query is slow and its results need to be cached…

    • 794 Words
    • 4 Pages
    Improved Essays

Related Topics