What are the similarities and differences between database, data warehouse, and data mining?

Write the DML code to add the first row of each table to the database.

Discuss the concept of data independence and explain its importance in a database environment.

Discuss in details the applications and challenges of Mobile Database in Public and Private Sector

Due to the high cost of fuel on the international and the current downturn in the economy the The Jamaica Light and Power Plant has made the decision to make twenty five positions redundant by the July 31, 2013.  Based on the Employment Termination Redundancy and Termination Act advise the affected staff members on the following

i)        Define redundancy                                                                                              ( 2 marks)

ii)      State clearly the conditions under which redundancy payments will be made and whether these staffs are entitled to redundancy payment.                                                       

iii)    Advise the staff of their entitlement based on their years of service.           ( 5  marks)

iv)    Advise the two members of staff who are on maternity leave their entitlement under

            the ETRP.                                                                                                      

1. We visually are not aware of a “blind spot” when both eyes are open because____?

1. the other eye is redundant so there is no need for it.
2. your eyes have different focal points and thus would give different answers.
3. light stimuli excite the same point on both retinas.
4. the blind spots of our eyes are not on corresponding points.
5. None of the answers are correct.

2.Sound, light, taste, touch and smell do not come in one level. We are able to describe the intensity of a stimulus (i.e. the intensity of ammonia salts or the brightness of a camera’s flash). What are the mechanisms used by the nervous system to communicate intensity via graded and action potentials?

Some people believe database technology may eliminate the need for double-entry accounting. This creates three possibilities: (1) the double-entry model will be abandoned; (2) the double-entry model will not be used directly, but an external-level schema based on the double-entry model will be defined for accountants’ use; or (3) the double-entry model will be retained in database systems. Which alternative do you think is most likely to occur? Why?

1.Explain the difference between file-oriented transaction processing systems and relational database systems. Discuss the advantages and disadvantages of each system.

2. What is the difference in logical view and physical view?

3. Describe the differences between the data definition language (DDL), data manipulation language (DML), and the data query language (DQL).

4. Describe a data dictionary.

5. Explain the relational database data model.

Search the Internet for services that provide access to business angels or informal investors. How do these sites work? If you were an entrepreneur looking for funding, how much would it cost to use this service? How many business angels are registered on the typical database? How many entrepreneurs are registered on the typical database? How effective do you believe these services are? (Use data where possible to back up your answer.)

1. Which of these is/are true about stored procedures?

1. A user defined stored procedure can be created in a user-defined database or a resource database

2. Repeatable & abstractable logic can be included in user-defined stored procedures

3. To call output variables in a stored procedure with output parameters, you need to declare a variables outside the procedure while invocation

4. Temporary stored procedures are nothing but system stored procedures provided by SQL Server