Use Excel to develop a regression model for the Hospital Database to predict the number of Personnel by the number of Births. How many residuals are within 1 standard error? Write your answer as a whole number.

Use Excel to develop a regression model for the Hospital Database to predict the number of Personnel by the number of Births. How many residuals are within 1 standard error? Write your answer as a whole number.

Create a report that lists customers with the total value of their orders from the database. Each row of the table should list the customer name and the total value of all orders. Rows should be in descending order according to the total. Just list the first 5 customers, those with the highest total orders.

This part is more complex and, so, can be approached in many ways. You may decide to use simple queries and put the information together using Python code. Alternatively, you might create a single SQL command that will produce the data needed.

Just one strategy will be outlined here, then some variants will be mentioned.

• Start an empty list for all customers
• Get a list of customers
  • For each customer get a list of invoices for that customer
    • initialize a variable to get the total of all invoices for the customer
    • For each invoice get a list of pizzas on that invoice
      • For each pizza, get a list of toppings on the pizza
        • Add up the costs of the toppings and add to the customer total
        • Add the crust price and sauce price to the customer total
    • Make a list of data about that customer and add to the list for all customers
• Sort the list for all customers
• Print the data

pizza_service.py

import sqlite3

class PizzaServices:

    def __init__(self):
        self.connection = sqlite3.connect("pizza-190807A.sqlite")

    def __enter__(self):
        return self

    def __exit__(self, exe_type, exc_val, exl_tb):
        crs = self.connection.cursor()

    def do_query(self, query, parameters=None):
        crs = self.connection.cursor()
        if parameters:
            crs.execute(query, parameters)
        else:
            crs.execute(query)

        return crs.fetchall()

    def customer(self):
        return self.do_query("select * from customer")

Consider the following set of requirements for a UNIVERSITY database that is used to keep track of students' transcripts.

(a) The university keeps track of each student's name, student number, social security number, current address and phone, permanent address and phone, birthdate, sex, class (freshman, sophomore, ..., graduate), major department, minor department (if any), and degree program (B.A., B.S., ..., Ph.D.). Some user applications need to refer to the city, state, and zip of the student's permanent address, and to the student's last name. Both social security number and student number have unique values for each student.

(b) Each department is described by a name, department code, office number, office phone, and college. Both name and code have unique values for each department. Each department has a faculty as a Chair to manage it.

(c) Each course has a course name, description, course number, number of semester hours, level, and offering department. The value of course number is unique for each course.

(d) Each section has an instructor, semester, year, course, and section number. The section number distinguishes different sections of the same course that are taught during the same semester/year; its values are 1, 2, 3, ..., up to the number of sections taught during each semester.

(e) A grade report has a student, section, letter grade, and numeric grade (0, 1, 2, 3,

4 for F, D, C, B, A, respectively).

(f) The database keeps track of each faculty’s name, faculty ID, SSN, address, email and office location.

(g) Each course section will have a faculty assigned as instructor.

(h) Each College controls several departments. Each College is described by a name, college ID and college office location. A faculty assigned as a Dean to manage a college.

Draw an ER diagram based on the requirement described here.

You should draw entity types, attributes and relationships in the ER diagram [10 points].

Specify key attributes of each entity type [2 points].

Use hierarchy structure to represent composite attributes. Use double lined oval to represent multi-value attributes [2 points].

The Active Directory database can be moved to a new location if you decide that there is a need to relocate it due to space limitations. How do you accomplish this? When you back up Active Directory, what must be included?

Explain the basic functions of a directory service and how Active Directory Domain Services fulfills them and describe how DNS names are formed out of domains and a hostname.

# Note: No plagiarism, please

Create a Database from blank (scratch) for a manager and name it. Create and design a table and name it. For each fields click and choose proper a data type such as short text and name the field. Make at least three fields. Enter your records. Make sure to add your name as a record.

Similarly create two more tables. By design tool, make a relationship between each of two tables at a time and drag a primary key one table to a secondary key of another table. For example one to one, one to many, many to one or many to many)

Run at least 5 queries of different important tasks on the data base

For this question I was given no data

You are hired to create a database for a Real Estate firm that lists and sells properties at multiple sales offices . Draw an ER diagram using ERDPlus for the following description of the firm, indicate all primary keys and cardinalities. List any assumptions you made.

There are many sales offices in several states. Attributes of a sales office include office number (identifier) and location. Components of location include Address (number & street), City, State and Zip.

Each sales office is assigned one or more employees. Attributes of employees include employee ID (identifier), employee name and phone number. An employee must be assigned to only one office

Each sales office has one employee assigned to manage that office. An employee may manage only the sales office he or she is assigned.

A sales office lists properties for sale. A sales office may have any number of properties listed or may have no properties listed. Attributes of property include Property ID (identifier), Property type and location. Components of location include Address (number & street), City, State and Zip.

When a property is listed the date of the listing and the price is recorded. A property may be listed multiple times but the dates must be unique.

Each unit of property has one or more owners. Attributes of owners are Owner ID (identifier) and Owner name. An attribute between property and owner is Percent Owned.

Consider the following information to design a database for a catalogue of an online video service that offers access to popular TV series.

The following is the description of the application:

• Each series has a name and a description.
• Each series has many episodes. Each episode of a series has an episode number, the date it was first aired, and the length of the episode in minutes. The episode number uniquely identifies an episode with respect to the series, but two different series can have the same episode number.
• Viewers can comment on any episode. For each comment, we want to record its post date, content and the first name/last name of the viewer who commented.
• In this database:
  • The name of each series is unique.
  • A user can comment on one or more episodes of any series.
  • You may add extra columns if you need for primary keys.
  • You can model the user as a separate entity but registering the username with each comment is also acceptable.

Based on the above scenario, draw an ER or UML diagram. You can draw the diagram using https://app.diagrams.net/ or manually. Please mention if you make any assumptions.

Mainstream spreadsheet and database software, such as Excel and Access, are often sufficient for analyzing the variety and volume presented by big data. T or F ?

Organizations that spend more on legacy systems tend to experience a lower incidence of security breaches. True or False ?

One of the challenges the accounting profession faces is that the tools accountants have traditionally used are ill-equipped for analyzing the types and quantity of data present in big data.

True or Flase

Draw the diagram (ER / MR / UML) for a database containing the following
characteristics:
• Presence sensor that stores presence information with its timestamp and its
location.
• Distance sensor that saves distance information with its timestamp and its
location.
• An actuator of a switch that energizes a bulb, where the record of its
been with your timestamp and your location.
• An actuator of a motor that opens a door, where the record of its
been with your timestamp and your location.
• A device that receives information from sensors and communicates with the
actuators, it can be an Arduino or any other board.