User Account

All Pages

Count how many employees have blue eyes and are married.

Assignment Help Database Management System
Reference no: EM13949661

Using the attached database WK5_DB_ACCESS2000.mdb write SQL queries to answer the following questions.

1. Show the employee (by name) that is shortest.

2. Determine the average number of years that the average employee has been working.

Hint: here's how to get started:

SELECT (Now()-[HIRE_DATE])/365 AS YEARS
FROM EMPLOYEES;

3. Count how many employees have blue eyes and are married.

4. Write the SQL to answer this question: which employees have the same letter starting their first name as their last name (every employee actually meets this criteria, but pretend you didn't know that and write the SQL to figure this out.)

Hint: the Left() function will be helpful. For example: SELECT Left([L_NAME],1)

5. Answer this question using SQL: show which eye color is most dominant in the employees (its Brown, with a count of 4 employees) - in other words, show the eye colors by count but only show the max value of count (4).

Attachment:- WK5_DB_ACCESS2000.zip

Reference no: EM13949661

Questions Cloud

Evaluating the quality of a two-phase liquid-vapor mixture : 1. Each of the following exercises requires evaluating the quality of a two-phase liquid-vapor mixture: (a) The quality of a two-phase liquid-vapor mixture of H2O at 40°C with a specific volume of 10 m3/kg is
Investigating possible vulnerabilities of microsoft iis : Case Project: Investigating Possible Vulnerabilities of Microsoft IIS 6.0, Carrell Jackson, the Web developer for Alexander Rocco Corporation, has informed you that Microsoft 115 6.0 is used for the company's Web site
Prepare a table that shows total cost of forming equipment : Prepare a table that shows the total cost of forming equipment rental and unit cost for units ranging from 0 to 50,000, using increments of 10,000 units.
Brief discussion of the extent to which the provided data : A brief discussion of the extent to which the provided data and/or your chosen method of analysis are appropriate and/or sufficient to test the biological hypothesis.
Count how many employees have blue eyes and are married. : Write the SQL to answer this question: which employees have the same letter starting their first name as their last name (every employee actually meets this criteria, but pretend you didn't know that and write the SQL to figure this out.)
Determine the specific volume at the state : 1. Complete the following exercises. In each case locate the state on sketches of theT-y and p-y diagrams.
Write two equations for the mesh currents : Write two equations for the mesh currents shown in standard form. find the values of i1 and i2 find the voltage V (over the 2 Ohms resistor) and the current i (over the 3 Ohms resistor)
Determine specified property at the indicated state : 1. For each case, determine the specified property at the indicated state. Locate the state on a sketch of the T-y diagram.
Critically discuss the variety of personality measures : Identify and critically discuss the variety of personality measures available to managers. Your response should consider the purpose of this testing from an organisational perspective.

Reviews

Write a Review

Database Management System Questions & Answers

  Create an xml schema for a catalog of cars

Create an XML document with at least three instances of the car element defined in the XML schema of Exercise 1, and produce a display of the raw document.

  Find names of all students who are enrolled in two classes

Find the names of all students who are enrolled in two classes that meet at the same time. Find the names of faculty members who teach in every room in which some class is taught.

  Create a database design specification enhanced entity

create a database design specification enhanced entity relationship diagram eerd and relational data model rdm from the

  Build an uml model in microsoft visio

Neatness of your diagram, please use the concepts of model, package, and sub-system well in the Visio model. Create both your diagrams under the static model from the model explorer in Visio.

  Identify the candidate key

For each of the following sets of FDs, assuming those are the only dependencies that hold for R, do the following: (a) Identify the candidate key(s) for R. (b) Identify the best normal form that R satisfies (1NF, 2NF, 3NF, or BCNF). (c) If R is ..

  Create an entity-relationship diagram

Create an Entity-Relationship (E-R) Diagram relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia

  Process the weather data for christchurch

Process the weather data for Christchurch and the West Coast of the South Island (as represented by Greymouth and Franz Josef) in the given dataset (hourly readings) and-focusing in particular on precipitation

  Perform large number of client-server requests into database

A small business with 100 computer workstations is installing a new local area network. All of the users perform the usual operations of e-mail. State your reasoning. Draw a floor plan for each If possible, show both floor plans on one page.

  Evaluate use of a distributed dbms structure is appropriate

Evaluate whether the use of a distributed DBMS structure is appropriate and identify the optimization techniques that should be factored in to enhance the operations of the database in your design.

  Compute the activity rates for the installing floors

Compute the overhead cost, according to the activity-based costing system, of a job that involves installing 3.2 squares - Prepare the first-stage allocation of overhead costs

  Design a database schema

Design a Database schema

  Prepare database design using the data definition

Prepare database design documents using the data definition, data manipulation, and data control language components of the SQL language.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd