1. Write a script which will Create the needed tables as follows: a. Table name : DEPT i. Column datatype Mandatory? Deptno NUMBER(2) Yes dname VARCHAR2(30) Yes loc VARCHAR2(20) No
PK? Yes No No
Ans: CREATE TABLE dept (deptno NUMBER(2) NOT NULL, dname
What information would need to come from Bluffs' Web and back-end systems to complete the order?
Input of the customer name or number would give the web portal access to the customer data. Upon entering the number of the requested item, the enterprise s
What information would Bluffs collect from the customer during this process? Ans: The Bluff's would collect basic details such as the Customer's name, Customer id, Contact
details, what address. product or service the customer requires, payment details, b
1. What do you need to do to correct it? Ans: Convert the case of the data into lowercase and then match it with the string 'boston' 2. Write the script to correct it. Ans: SELECT deptno AS Department_No, dname AS Department_Name, ename AS Employee_Name,
What about if we want to efficiently keep track of the lengthy Skill description? What is the best way to implement this ? Ans: have to create the skill table with a column to hold the description of the skills.
Use SQL*Loader For dept table: Control File: load data infile 'dept.dat' "var 3" into table dept fields terminated by ',' optionally enclosed by '"' (col1 NUMBER(2), col2 VARCHAR2(30), col3 VARCHAR2(20) ) From Command Prompt: SQLLDR CONTROL=dept.ctl, LOG=
a. Table name: EMP i. Column Empno ename Hiredate Job Mgrno emp.empno) Salary Comm Deptno dept.deptno)
datatype NUMBER(4) VARCHAR(2) DATE VARCHAR2(15) number(4) number(8,2) number(8,2) number(2)
Mandatory? Yes Yes No No no no no no
PK? Yes No No No no no
a) Suppose there is a rating of the competency for each skill an employee possesses, where in the data model would we place this rating? The Has Skill associative entity, that associates a single instance of a SKILL with a single instance of an EMPLOYEE,
What is the role of the system developer with respect to the development of accounting information systems? Ans: The main responsibility of a system developer is to manage the internal processes of computer systems. A system developer works with organizat
a) In what way might Pine Valley change the way it does business that would cause the Supplies associative entity to be eliminated and the relationships around it change? According to current business practice at PVFC, each RAW MATERIAL is provided by 1 o
1. Add to the script code that will populate the above two tables with the following data a. Use Insert statements Ans: INSERT INTO dept (deptno,dname,loc) VALUES (10,'Accounting','Boston'); INSERT INTO dept (deptno,dname,loc) VALUES (20,'Sales','Boston')
1. Add to the script a SELECT statement which will output the department no, dept name, Ename and hiredate for all department in `boston'. Answer to #4 SELECT d.deptno, d.dname,e.ename,e.hiredate FROM emp e, dept d WHERE d.deptno=e.deptno And dname='bosto
Note: SECTION is modeled as a weak entity. It could have been modeled as a multivalued attribute; however, using a weak entity is better, since SECTION may have a relationship with another entity. A multivalued attribute could not be used to show thi
Assignment: All three entities participate in the Assigned relationship that is modeled as an associative entity Assignment, since the Assign Date for each CHEMIST's assignment to a particular project and equipment item must be tracked. However, EQUI
4c) The native notation used in ERDs does not show whether membership in a relationship can change (i.e., whether a volunteer can change agencies or whether an agency can change its volunteers). Some DBMSs can be told whether membership can change or not,
Why must you have knowledge of a system's objectives to study that system? Ans: Understanding and evaluating a system's procedures must be studied in light of the system's
objectives. For example, in an accounts receivable process, we periodically send cu
Why might you have more trouble assessing the success of a not-for-profit organization or federal government entitlement program than you would have judging the success of a business organization? Ans: The purpose of this question is to understand the rel
a) Why is Includes a one-to-many relationship and why might this ever be different in some other organization? Includes is a one-to-many (1:M) relationship because of the business rules that PVFC has in place: "a product line may group any number of produ
a) What is the meaning of the Does Business In associative entity and why does each Does Business In instance have to be associated with exactly one TERRITORY and CUSTOMER? The Does Business In associative entity associates a single instance of a TERRITOR
What is Managerial Accounting? Ans: Management accounting or managerial accounting is concerned with the provisions and use of accounting information to managers within organizations, to provide them with the basis to make informed business decisions that
What is forensic accounting?
Ans: Forensic accounting, or financial forensics is the specialty practice area of
accountancy that describes engagements that result from actual or anticipated disputes or litigation. "Forensic" means "suitable for use in a c
What is financial accounting? Ans: Financial accountancy is the field of accountancy concerned with the preparation of financial statements for decision makers, such as stockholders, suppliers, banks, employees, government agencies, owners, and other stak
1. If it weren't for the potential of computer crime, the emphasis on controlling computer systems would decline significantly in importance." Do you agree? Discuss fully.
Ans: Without computer crime, and the attendant, fascinating stories, public awarene
How, or in what ways, is information used in management decision making? Ans: Literature on the information behaviours of managers was found to be plentiful in the subject areas of Business Management, Organizational Behavior, Psychology, and Information
How would an enterprise system facilitate this exchange of information? Ans: An information system supports the functioning of an organization in several ways. First, it facilitates the functioning of the organization's operations as business events occur
Prepare a one page essay on what your reactions were to the Frontline program that was aired on January 22nd. Do you believe that there were fraudulent activities? Should people and organizations be held accountable? Other thoughts?
The Frontline program