our company is creating the database for the sales system. These are the major components: Database design User entry form design Report design Access and authentication Maintenance You are assigned as an IT manager. For this Discussion, gather information from the library and research other web resources. Write a plan describing your role in designing, developing, managing, and supporting the database.

d- What is the purpose of a feasibility study (or feasibility analysis)?

e- What is one advantage and one disadvantage of a centralized database compared to a distributed database?

f- What is the deletion anomaly problem that databases try to avoid?

g- One problem that good database designs try to solve is the "data insertion problem." What is the data insertion problem?

Database Management Systems for Business

5. Name the data model that is only used to document a database design.

6.         State the most important characteristics regarding the output of any relational algebra operation.

7. Name the software system that permits the data in a distributed database to be transparent to users.

8. Use two words to distinguish a file based systems and a database.

9.        Name the level to represent an organization view in the three-level ANSI-SPARK architecture.

10.       Name the terminology of storing subject-oriented, integrated, time variant and nonvolatile data for generating useful decision making report.

11. A business rule says that an employee cannot earn more than his/her manager.
Assume that each employee row has a foreign key which refers to a manger row.
a. Can this business rule be implemented using a fixed format constraint?
b. Can this business rule be implemented using a trigger?
12. Triggers should be created sparingly. Why?
13. Should you use a trigger to check the uniqueness of a primary key?

14. What is a Distributed Database system?
15. What advantages does a Distributed Database have over a Centralized Database?
16. Why do some users require data from multiple sites in a Distributed Database?

17. What is Horizontal Fragmentation within a DDBMS?

Note: Questions are based on DBMS (Distributed database and triggers)

Subject (DBA)

use MYSQL workbench select my guitar shop database as default schema

Question text

Problem10

Write a script that implements the following design in a database named household_chores:

Details

• Include a statement to drop the database if it already exists.
• Include statements to create and select the database.
• Include any indexes that you think are necessary.
• Specify the utf8 character set for all tables.
• Specify the InnoDB storage engine for all tables.

Solution

______ DATABASE IF EXISTS ______ ;

CREATE DATABASE household_chores CHARSET _________ ;

________ ;

______   _______ (

         person_id       INT          PRIMARY KEY ______ ,

         first_name    VARCHAR(50) NOT NULL,

         last_name     VARCHAR(50) NOT NULL

) ENGINE = InnoDB;

CREATE TABLE chores (

         chore_id   INT         PRIMARY KEY _______

         name VARCHAR(100) UNIQUE

) _______

CREATE TABLE tasks (

         task_id   INT         PRIMARY KEY AUTO_INCREMENT,

         chore_id INT,

         name   _______ UNIQUE,

         CONSTRAINT fk_tasks_chores

                 _________

                 REFERENCES _______

) _______ = InnoDB;

CREATE TABLE assignments (

         _______    INT         PRIMARY KEY AUTO_INCREMENT,

         person_id   ______ ,

         task_id   INT,

         _______ fk_assignments_people

                 _______

                 REFERENCES _______ ,

         CONSTRAINT fk_assignments_tasks

                 ______

                 _______ tasks (task_id)

_______

A pediatrician randomly selected 50 six-month-old boys from her practice's database and recorded an average weight of 15.6 pounds with a standard deviation of 0.45 pounds. She also recorded an average length of 25.7 inches with a standard deviation of 0.27 inches.

(a) Find a 95% confidence interval for the average weight (in pounds) of all six-month-old boys. (Round your answers to two decimal places.)_____ lb to______ lb

(b) Find a 99% confidence interval for the average length (in inches) of all six-month-old boys. (Round your answers to two decimal places.) in ____ to ______in

(c) What do you have to assume about the pediatrician's database in order to make inferences about all six-month-old boys?

1. The pediatrician's database must contain all measurements from the entire population of six-month old boys.

2. The pediatrician's database must be updated daily.

3. The pediatrician's database must produce intervals that contain the respective sample means.

4. The pediatrician's database must be kept secure using state of the art security software.

5. The pediatrician's database must be representative of the entire population of six-month old boys.

You need to implement a web application that is split in three parts, namely, Webpage, PHP and Database. Each of them will be employed synergically to solve the simple problem described below. Your implementation should be able to resist all the most common security threats.

Webpage: This is the main page of your application. It would contain two sections, ADD and SEARCH: ADD section contains:

-A text box to input an Advisor name

-A text box to input a Student name

-A text box to input the Student ID code

-A text box to input the class code

-A button to allow the user to add the above specified data in the Database

SEARCH section contains: A search box (with corresponding button) that allows the user to query the database for Advisors name

PHP:

-Implement one or more PHP functions that read the inputs from the ADD section of the Webpage and prepare the corresponding query to add the record in the Database.

-Implement one or more PHP functions that read the input from the SEARCH section and prepare the corresponding query for the Database.

-Implement a function that, when a search is made in the SEARCH section, it shows in input the result of the query

Database: You need to create a database that contains at least a table to store the information in input to the webpage.

The Somerton High School PTO is creating a website that will allow students to quickly look up their homework assignments. The database supporting this website will keep track of departments, teachers, classes, and assignments. Each department has a name such as “Math”, “Science”, or “English” and each teacher is a member of a single department. For each teacher, the database should store a title (“Mr.”, “Ms.”, “Dr.”, etc), first name, middle initial, last name, office phone number, and e-mail address. Each class is taught by a one teacher; for each class, the database should store a name, description, meeting period (for example, seventh period), and room number. Finally, each class has multiple assignments. For each assignment, the database should store the date assigned, the date due, and a text description of the work assigned. Obviously, the database also needs to remember which class each assignment is for, and which teacher teaches each class.

A. Design a database to hold all this information. You may create synthetic keys as necessary or convenient.

B. Write outline notation and justify the primary key you have chosen for each table in the database.

C. In Access, create all the necessary tables for this database, and choose a reasonable datatype for each attribute. Assume phone numbers are in standard US format. If you use any “AutoNumber” synthetic primary keys, note that a matching foreign key should have a datatype of “Number”, with a field length of “Long integer”. Create all necessary relations between the tables and enforce referential integrity. You do not have to enter any data or create any forms. Create a “Documenter” report for the database.

System Requirements

There are many categories of people that need to be tracked in the PAN database. Each person may fall into more than one of the following categories: clients, volunteers, employees, and donors. PAN tracks the name, social security number, birth date, race, gender, and profession of each person. In addition, PAN stores the contact information for each person consisting of a mailing address, email address, and home, work, and cell phone number. PAN also sends a monthly newsletter to people on its mailing list, so the database should indicate whether or not each person in the database is on that list. Finally, the system should have the ability to store a list of emergency contacts for the people in the database. This information should record the name and contact information for each of the emergency contacts along with their respective relationship to the person in the database.

PAN tracks its list of clients in the database. For each client, PAN tracks the name and phone number of his or her doctor and attorney. PAN also tracks the date the client was first assigned to the organization. Each client has a list of needs. Examples of these needs include visiting, shopping, housekeeping, transportation, yard work, and food. Each of these needs is also associated with a value indicating its importance to the client (1-10). PAN also tracks the list of insurance policies that each client has. Each insurance policy has a unique policy id, a provider id, provider address, and a type such as life, health, home, or auto.

PAN provides care for each client using teams that contain many volunteers. Each team cares for several clients, and more than one team may care for a client. Each team is identified by its name, and each team also has a type and a date it was formed. A volunteer may serve on multiple teams. For each volunteer, the database should store the date he or she first joined PAN and the date and location of his or her most recent training course. In addition, PAN should record the number of hours a volunteer worked each month for a particular team. Note that the volunteers do not work the same number of hours each month. One of the volunteers on a team serves as the team leader. This information should be tracked in the database as well. In addition, volunteers and clients may switch teams; so, the database system should provide the ability to mark whether or not each volunteer and client is active or inactive on a specific team.

Every team reports periodically to one PAN employee to discuss its current status, and more than one team may report to the same employee. The database should record the date of each report as well as a description of its content. For each employee, the database should store the employee’s salary, marital status, and hire date. An employee may charge several expenses each month. The database should track the date of the expense, along with the amount and its description.

PAN depends on support from its donors. The database should track these people as well as record each of their donations. This information should include the date, amount, and type of donation along with the name of the fund raising campaign that generated the donation if it is applicable. If the donation was made by check, the database should record the check number. If the donation was made by credit card, the database should record the card number, card type, and expiration date. In addition, each donor may wish to remain anonymous, so the database should record that information as well.

Each person in the database may be affiliated with an external organization. The database should track this information as well. Each organization should have a unique name, mailing address, phone number, and contact person. In addition, each organization may sponsor one or more PAN teams, and a team may have more than one sponsor. If the organization is a business, the database should record the business type, size, and company web site. If the organization is a church, the database should record its religious affiliation. Each organization may also make several donations to PAN, and the database should track the same donation information as it does for individual donors. This includes the ability for the organization to make anonymous donations

Question 1: Construct and ER diagram for the above System Requirements

Now that Hermione understands empirical formulas she wants to teach Harry and Ron. What is the empirical formula for dibromoethane: C₂H₄Br₂

A. CH₂Br₂

B. CH₂Br

C. C₂H₄Br

D. CHBr

E. C₂H₂Br₂

2.Calculate the maass percent composition of carbon in C​_​2​H_​5Cl.​