DATE: 25.06.2013 EXP.NO: 1 PAYROLL AIM: To create database for the salary details, perform various operations like insert, delete, update, search, and prepare necessary report. TABLE DESCRIPTIONS: ➢ SQL> create table payroll(Empno number(10),empname char(15),dept_id number(5),dob date, BP number(5),DA number(5),HRA number(5),PF number(5),CCA number(5),MA number(5),LOAN number(5),Grosspay number(5),Netpay number(5)); ➢ SQL>desc payroll; Name
Words: 331 - Pages: 2
Databases and Data Communications Scenarios Devin Winston BIS/320 Cornell Perry University of Phoenix November 24, 2014 In the two scenarios provided there are important questions that need to be answered. It is important to think of all the options and come up with the best solution. This essay will try to give insight to a solution that is the best fit for each scenario. Scenario 1: You are a marketing assistant for a consumer electronics company and are in charge
Words: 1097 - Pages: 5
SQL Fundamentals The Structured Query Language (SQL) comprises one of the fundamental building blocks of modern database architecture. SQL defines the methods used to create and manipulate relational databases on all major platforms. At first glance, the language may seem intimidating and complex but it's really not all that bad. In a series of articles over the next few weeks we'll explore the inner workings of SQL together. By the time we're through, you'll have the fundamental knowledge you need
Words: 1859 - Pages: 8
Data Base Management Systems (DBMS) Study Material (Objective Type questions with Answers) Shared by Akhil Arora Powered by www.Gr8AmbitionZ.com your A to Z competitive exam guide DMBS Ojbective Type Questions - Akhil Arora Q.1 In the relational modes, cardinality is termed as: (A) Number of tuples. (C) Number of tables. Ans: A Q.2 Relational calculus is a (A) Procedural language. (C) Data definition language. Ans: B Q.3 The view of total database content is (A) Conceptual view
Words: 3574 - Pages: 15
a) What trends are occurring in the development and use of the major types of computer systems? Every day there are new developments. New products are launched and new product ideas and applications of information technology involve. As we can see the trends development of computer systems can be seen from it physical and functions. Computers now days a becoming smaller but had more memory, user friendly, reliable to use, and more efficient for user to bring it travelling as it can be connected
Words: 1882 - Pages: 8
(Departments) As shown in diagram 1, a 3-layer Relational database separates the physical database from the user applications. The following schemas are defined at each of the following levels: * Internal * Conceptual * External “The DBMS is responsible for mapping between these
Words: 2877 - Pages: 12
Individual Project On Allocation of answer script among the college teachers using automation process instead of manual process: The case of Directorate of Secondary and Higher Education, Bangladesh, Dhaka [pic] Course: PPG-505 [Organization Theory and Behavior] Submitted to: Dr. Tawfique M. Haque Deputy Director, MPPG Program and Associate Professor North South University Submitted by: Laila Parvin Suchi ID No: 1412128085 MPPG Program, 5th Batch, North
Words: 2885 - Pages: 12
GENERALIZED TECHNICAL DATA PROCESSING: 1. Moore’s Law: Actual Meaning – April 1965 Gordon made an observation that approximately every 18-24 months twice as many semiconductors can be stored on a chip/ double storage capacity (NOT a LAW) 2. Moore’s Law: Generalized meanings – the speed of computers is set to double every two years 3. Central Processing Unit (CPU) and the three primary components thereof – the electronic circuitry within a computer that carries out the instructions of
Words: 2665 - Pages: 11
Database Systems and How They are Used DBM/380 Week 1 Individual Assignment Craig Gruenbaum Instructor: Kevin Judge Database Systems and How They are used Database systems are utilized in basically every business every day. Businesses use data to perform a multitude of functions, such as sales transactions, customer queries, and the viewing of key performance indicators. Database systems are the management tool that aids in accessing this data. “In a sense, a database resembles
Words: 497 - Pages: 2
organizational issues and needs and developed conceptual, logical, and physical designs of DBMS solution. In order to implement the solution, substantial research had been done on best practices in design, available products, and the legal and ethical standards to which we must adhere during design. This paper includes Business rules, Conceptual, Logical, and Physical database designs, Recommendations on best DBMS required for Grandfield College, Data model, Legal Compliance, Ethical Practices, Security
Words: 4672 - Pages: 19
