Posts

Showing posts with the label Database Oracle or MS Access or Mysql or MsSQL

Introduction about the Popular Economists Of Different Periods

Introduction about the Popular Economists Of Different Periods                 By: Dipendra Nepali Submitted To: Laxmi Paudel, Lecturer of Economics Nobel Academy Faculty of Management (+2) HSEB Kathmandu November 2010 Adam Smith   Born: 16 June 1723( OS : 5 June 1723) Died :17 July 1790 (1790-07-17) (aged 67) Era: Classical economics Main interests : Political philosophy , ethics , economics Notable ideas: Classical economics , modern free market , division of labour , the " invisible hand " Aristotle  · Butler  · Cantillon  · Chydenius  · Hobbes  · Hume  · Hutcheson  · Locke  · Mandeville  · Petty  · Quesnay Belgrano  · Comte  · Darwin  · Engels  · Friedman  · Hayek  · Hegel  · Keynes  · Marx  · Malthus  · Mill  ·  · Rand  · Ricardo  · US Founding Fathers carl menger stanley jevons economics Signature: In his word ,”Economics is the study of t

Question of Nobel College DBMS 2005

Image
NOBEL COLLEGE Sinamangal, Kathmandu Final Assesment 2005 Section :BCIS IV                                                                               F.M 100 Subject : DBMS                                                                                P.M 50                                                                                                             Time:3 hrs      Attempt all the questions. 1.         a.   Explain the advantages and disadvantages of the DBMS [8]             b   What are the various component of DBSM                      [7] 2.         a.  Explain the E-R data model with the suitable example.    [9]             b) Explain the importance of feasibility study in database design [6] 3.         a.   Explain the importance of the normalization in database. Explain about the first, second and third normal form. [9]             b.   Consider the following table with the given functional dependencies, primary keys are und

The main object of this lab is to be familiar with the DML(Data Manipulation Language)

DBMS LAB 4 The main object of this lab is to be familiar with the DML(Data Manipulation Language) Deleting Records             To delete a record MySql uses the DELETE statement. It is similar to SELECT, except that as the entire record is deleted, there is no need to specify any columns. You need the table name and condition. The general syntax of the DELETE command is msql> DELETE from table_name where condition; Example: mysql > DELETE from employee_data where [condition] NOTE: condition is optional.If condition is not given all the data from the table are deleted. So be careful to use a condition with the DELETE statements.Simply entering DELETE from table_name would have deleted all records in the table. There is no undo option Changing Records in Table UPDATE statement is used to update the records in table. The general syntax for the UPDATE statement is mysql>UPDATE table_name SET column_name=value where condition; In this statemen

How to perform DBMS Lab and its methodologies

DBMS LAB The main objective of this lab is to gain knowledge of the select statement that is used SQL Querying MySQL tables Data is extracted from the table using the SELECT SQL command. Here is the format of a SELECT statement: SELECT column_names from table_name [WHERE ...conditions]; The conditions part of the statement is optional. Basically, you require to know the column names and the table name from which to extract the data. SELECT f_name, l_name from employee_data; The statement tells MySQL to list all the rows from columns f_name and l_name. The display is in the order in which the data was inserted. Furthermore, the last line indicates the number of rows our table has. To display the entire table, we can either enter all the column names or use a simpler form of the SELECT statement. SELECT * from employee_data; Some of you might recognize the * in the above statement as the wildcard. Though we don't use that term for the characte