The following information is stored in two relational database files:Employee Master FileSocial Security numberNameAddressDate hiredHourly wage rateMarital statusNumber of exemptionsWeekly Payroll FileSocial Security numberHours workedDeductionsBonusesRequireda. Bogey works in personnel and Bacall works in payroll. Prepare a database authorization table that you think is appropriate for Bogey and Bacall for these two files.b. Discuss any potential exposure if the right prevention devices are not in place or if Bogey and Bacall collude.

Q: A company X has hired you to manage its database. Choose a subject and propose a database for the…

A:

Q: a) Consider the relational schemas of the TPCHR sample database. Determine what index should be…

A: Since there are multiple subparts, we will provide the answer for the first three subparts. If you…

Q: When would it be reasonable to make the assumption that two select statements taken from the same…

A: It is possible to have union compatibility if both tables include the same number of characteristics…

Q: When would it be reasonable to make the assumption that two select statements drawn from the same…

A: It would be reasonable to make the assumption that two SELECT statements drawn from the same…

Q: You have just been employed by the ROBCOR Trucking Company to develop a database. To gain a sense of…

A: ER Diagram:

Q: a) Create the proper database using sql queries that stores students information (ID,Name) with…

A: create database student_info  -- creating the database --creating the student tablecreate table…

Q: Consider the database whose database state shown in appendix and answer the following questions:…

A: (A) Retrieve the name of all employees who work in the “Research” Department Select E.Fname,…

Q: Q1\ if your database has the information in figure below make the database easy to update and…

A: Normalization

Q: What are the names of four properties that should be satisfied for all database transactions? Select…

A: Atomicity: It refers to not only a part but the integrity of the whole database transaction. That…

Q: Please written by computer source There are 2 parts to this assignment Unit 6 - Part 1--Prepare a…

A: Some important terms: Business/Organization: Refers to the entity for which the database is being…

Q: What is the balance (total across all accounts) for customerid=42?

A: Please check the step 2 for solution

Q: 4. Use an appropriate database application to design a database for a school record. Name it…

A:

Q: Stylish Shoes started operations as a small retailer of high-end footwear in Christchurch. Over the…

A: 1) how relational database works 2) problems with file based legacy system

Q: default character. What SQL statement should you use to create the database? You are creating a…

A: A database is basically a storage system that stores data in huge amounts. It is virtual in nature…

Q: i). List the names of all the authors in the database, and beside each name give the number of books…

A: The SQL query is given below  We have used INNER JOIN here.

Q: Create a user with the name IS Sead and password a789 and give him permission to connect to the…

A: MySQL is an open source relational database management system. It has been used in the WordPress…

Q: You have just been hired on as a Database Developer, and your employer has provided you with the…

A: A trigger is a particular kind of database item that runs automatically in reaction to certain…

Q: write the steps to design new database file as (subjtable1.dbf) that consists .(of (2) fields:…

A: Steps to design the database named subjtable1.dbf in MySQL database: Use create table command to…

Q: 2- Use Lucidchart to create a Crow’s Foot notation ERD to support the following business operations:…

A: Professional Electronics and Repairs (PEAR) is a budding electronics repair shop catering to the…

Q: Give the function of each of the following 1.union 2.database 3.Right join 4.Left join 5.insert|

A: union operation is used to combine the result of 2 queries

Q: Since you have been hired to work on a database, you may decide whether to use a trigger or a…

A: Your answer is given below.

Q: Assignment 4: Question#1: Give any three examples of transaction where next operations are…

A: A transaction is a set of tasks to perform and complete a particular operation. To keep the…

Q: 104. The state in which the database does not follow integrity constraints is classified as a.…

A: Here is the solution which is  mentioned below:

Q: 107. On a relational database, the kind of constraint which must be specified and does not contain…

A: please see the next step for solution

Q: Woody Jr. took over Woody's Working Shop from his parents. His parents had not updated their…

A: Database design for the wood inventory mangement can be made as: Wood table:Table 1 Wood_code…

Q: What types of additional information and constraints would you like to represent in the schema

A: Given Data:    (SSN INT NOT NULL,             FNAME VARCHAR2(20),             M VARCHAR(1),…

Q: CUSTOMER Ữ CustomerID FirstName LastName Phone EmailAddress INVOICE InvoiceNumber Customer D Dateln…

A: Schema Structure- --------------Customer---------------- CustomerID (Primary Key)- FisrtName-…

Q: Assume an Oracle database administrator has connected to a pluggable database. What will be the…

A: In this question we have to understand about the SQL statements which Oracle database administrator…

Q: this is an ITSE 2356 COURSE ,we use Iggy fernandez and Bob Bryla as a reference :   Case:  As of…

A: Hello student

Q: University laboratory has several chemists who work on one or more projects. Chemists also may use…

A: University laboratory has several chemists who work on one or more projects. Chemists also may use…

Q: in mysql Take a picture of the inputs and outputs Create a user with the name IS Sead and password…

A: Following are the input and output of creating a user named ISsead: When testing the connection,…

Q: y Germany x 030-00765

A: After than we insert the data into the table.

Q: 1. Create the table with the following specification shown below: Database name: Oasis. Table name :…

A: We are using mysql for this. Create database as shown below: mysql> create database BB;Query OK,…

Q: ith respect to relational databases, which of the following statement is true? O An insert anomaly…

A: Foreign key are primary key of a table and is present in some other table to establish the…

Q: Q2. (4 points) Assume we have the following two tables and their instances: CREATE TABLE…

A: After running the following query DELETE FROM Project P WHERE P.pid=100 or P.pid=200 New instances…

Q: 5. Assuming that the two one-dimensional arrays de following code display? val 11 4 6. 8. 10 nums…

A: Given: int[] val = {3,5,7,9,11};      int[] nums = {2,4,6,8,10};      nums = val;      nums[0] = 33;…

Q: onsider the following set of requirements to maintainaSmartBuy store database: •You should…

A:

Q: Client (clientNumber, firstName, lastName, clientCity) Account(accountNumber, #agencyNumber,…

A: For the required query creating the first three tables:   (here, underline cloumn names are the…

Q: The database used for this question is a very simple one with the following schema: (Primary keys…

A: a. We have selected the first name and last name attribute using project symbol, City named Perth…

Fundamentals of Datawarehouse

A data warehouse is a data repository which is used to store large quantities of historical data that are mostly used for creating reports that help businesses to identify their weaknesses and strengths. For example, demographics data about people of a region can help businesses identify the needs and preferences of the region’s population. A data warehouse acts as a central storage for storing data that comes from one or more heterogenous sources. It also consists of data which can be old and of historical value. One of the most important applications of this type of system is that it is used for supporting business intelligence and data analytics applications.