Blog

Trey wants to insert three identical triangles on a slide. Which of the following methods is the best way to do this?

To perform effectively and compassionately as a radiologic sciences professional, it is important to understand the areas of human cultural diversity. These may include1.   social organizations.2.   phobias.3.   symbolism.4.   space.5.   time.6.   communication.

Take a look at this ERD and check all that applies:  

You’ve been assigned to do an IT audit on the Johnson Company’s database, a company which owns 25 restaurants across California and Arizona. After interviewing the CEO, CFO and end-user employees, you have developed the following business rules:  1) A restaurant has many employees and an employee works at one restaurant only2) Each employee has a manager who is also an employee (and manages many other employees)3) Each employee is assigned many job tasks and a job task is performed by many employees 4) For each of the 25 restaurants, Johnson Company tracks a unique branch identifier (RestaurantID) as well as the assets, city, and zip code.5) For each employee, the company records the employee ID, first name, last name, date of birth, manager ID, and type of employment.6) There are two types of employment: full-time and hourly. For full-time employees, they record the annual salary. For the hourly employees, they record the hourly wage. 7) For job tasks, they keep track of the task ID, name, and description. In your conceptual model you will have (check all that apply):

Fill in the blank with one word in each blank. The written form of the conceptual model for a database is called: [resp1] and the graphical form is called : [resp2]

Given the following tables: Write a SQL code to list the customers (customer ID, first name, last name, state, and zip code) who spent at least $500 in 2022.

Examine the SQL code below: SELECT RestaurantID,              RestaurantName,              RestaurantLocation,            COUNT (DISTINCT CustomerID) AS [Number of Customers]FROM RestaurantGROUP BY RestaurantID,                   RestaurantName,                   RestaurantLocationHAVING [Number of Customers] > 100ORDER BY RestaurantName; Select the right answer:

Given the following tables: Write a SQL code to provide the average length of time (in days) between sale date and shipping date by state. Your report should include the state and the average length of time. Order your list from the largest to the smallest time interval.

A local health clinic in Tempe asks you to build a database to help them record patients’ consultations. Based on the clinic processes, you create the ERD and data dictionary presented below.        Write a SQL code to create the database.

Examine the SQL code below: SELECT Department,                AVG(Salary) AS [Average Salary by Department]FROM EmployeeGROUP BY DepartmentHAVING AVG(Salary) > 100000ORDER BY 2 DESC ; Select the right answer: