Chapter1:Introduction
DatabaseSystemConcepts,5thEd.
Silberschatz,KorthandSudarshan Seewww.dbbook.comforconditionsonreuse
Chapter1:Introduction
s PurposeofDatabaseSystems s ViewofData s DatabaseLanguages s RelationalDatabases s DatabaseDesign s Obje
Siddharth Ambatipudi
CSB 311
Bradmark Case
CH:9 Revenue Cycle Issues
1. From what was given in the case file, Bradmark had a lot of room for
improvement in its internal controls department. Bradmark appears to have many
flaws in its expenditure cycle proc
CH:10 Expense Cycle Questions
1. Bradmark appears to have many flaws in its expenditure cycle procedures that
could lead to fraud in a variety of ways. Firstly, James Walker was the designer
for the IT department as well as the person in management in cha
CSE202, Spring 2015
Data Lab: Manipulating Bits
Assigned: Jan. 21, Due: Mon., Feb. 2, 11:59PM
1 Introduction
The purpose of this assignment is to help you become more familiar with bit-level representations of integers
and floating point numbers. Youll do
6-1
The first control technique that can be used to prevent this fraud scheme is that the person who reviews
checks should not also be the person to submit them. The payroll department should review the work
first and make sure that there is someone to ta
Homework Assignment 1
CSB 311
Professor Hall
1.
a.
2.
i. Management consists primarily of the CFO and CEO in this case. They made the
conscious decision to create an internal audit system so that they can comply with
SOX and PCAOB requirements. They do no
Siddharth Ambatipudi
CSB Homework Assignment 7
04/06/2015
1. Dear Mr. Roger Moore,
I hope that you are doing well today. I just have some questions and considerations that should
be taken into account with regards to the new accounting system that is bein
Siddharth Ambatipudi
CSB HW 2
2/9/2015
3-2
1. Segregation of Functions
a. The risk with the following tasks is that the sales manager only gets a commission if they
make a sale and get the cash. However, they will not get any cash if they sell an item on
Siddharth Ambatipudi
CSB 311
Homework Assignment 11
Problems 1,5,8,12
1. As with any purchase of a new system, the Harvey Company will have many new internal
controls to assess to ensure good efficiency in their company. Firstly, the company has to ensure
Siddharth Ambatipudi
CSB 311
Bradmark Case
CH:9 Revenue Cycle Issues
1. From what was given in the case file, Bradmark had a lot of room for
improvement in its internal controls department. Bradmark appears to have many
flaws in its expenditure cycle proc
Siddharth Ambatipudi
CSB 311
02/20/2016
5-2
a. A requisition order is a form that a department must submit to whichever department controls
the financial activities of the business. Requisition orders involve a department requesting
materials, supplies, a
Homework 1: SQL
Due Thursday Feb 2, 2017 by 10:45am
CSE 241: Spring 2017
For each question, we give a query in English that you are to write in SQL and run against the university
database on Edgar0 belonging to user dbcourse. The schema for this database
Homework 1: SQL
Due Tuesday Jan 27, 2015 by start of class
CSE 241: Spring 2015
For each question, I give a query in English that you are to write in SQL and run against the university
database on Edgar1 belonging to user dbcourse. The schema for this dat
Homework 2: SQL
Due Tuesday Feb 3, 2015 by start of class
CSE 241: Spring 2015
Save your SQL queries and submit a single .txt format le containing all of your queries. Do NOT submit
the result relations.
These queries are to be done using a single SQL sta
Homework 3: SQL
Due Thursday Feb 5, 2015 by start of class
CSE 241: Spring 2015
Save your SQL statements and submit a single .txt format le containing all of your SQL statements
(and your explanation in question 1). Do NOT submit the result relations.
In
Homework 4: ER Design
Due Tues Feb 10, 2015 by start of class
CSE 241: Spring 2015
1. Construct an E-R diagram for a part of a university database pertaining to athletics. The school oers
several sports (e.g. football, soccer, baseball, cross-country, tra
1) Use of the avg() aggregator with the salary attribute exludes null values. One of the instructors, Proffesor Uno, has a null value for his salary. The avg() aggregator takes an average based off of the total salary divided by the number of salaries cou
1. Find the name of the instructor whose ID is 41986.
Querie:
select name
from instructor
where id = '41986';
2.Find the course ID and grade for those courses for which a section is taken by the student with ID
48575. Show the result in order of course ID
1.)
select avg(salary)
from instructor
where dept_name = 'Accounting';
2.)
select distinct student.dept_name, avg(student.tot_cred) as AVERAGE_CREDITS
from student
group by dept_name
order by dept_name asc;
3.)
select course.course_id
from section, course
Question 1:
Student
ID
Name
Plays
ID
Type
Sport
Type
Leugue
Tte
Question 2:
Combining each entity into one entity would create the need for null values to be
Entered in cases where students either do not participate in a sport, or participate
In a sport a
Homework 2: SQL
Due Thursday Feb 9, 2017 by 10:45am
CSE 241: Spring 2017
Save your SQL statements and submit a single .txt format file containing all of your SQL statements
(and your explanation in question 1). Do NOT submit the result relations.
In this
Homework 1: SQL
Due Thursday Feb 2, 2017 by 10:45am
CSE 241: Spring 2017
For each question, we give a query in English that you are to write in SQL and run against the university
database on Edgar0 belonging to user dbcourse. The schema for this database
Siddharth Ambatipudi
CSB HW 2
2/9/2015
3-5
1. Segregation of Functions
a. The risk with the following tasks is that the sales manager only gets a commission if they
make a sale and get the cash. However, they will not get any cash if they sell an item on
