Welcome To edutwin.com ..! Here you can see Seminar Topics & Project Ideas , assignment, question answers, career guidence ,old question papers, quiz , job posting , ppt pdf doc presentation Abstract and documentation for Computer Science ,ECE, Communication, MCA ,BCA, BBA, MBA, Electronics, Electrical, Mechanical Engineering, Civil, Medicine, Technical, Nursing, Pharmacy, Science, Physics, Mathematics, Chemistry,Gerneral,B.tech,M.tech,all degree,PG,diploma,exam result,resumes,research concepts,tutorials and lot more
Viewing mode Threaded Mode | Linear Mode
Database Management System (DBMS)
Thread Rating:
  • 12 Votes - 3.08 Average
  • 1
  • 2
  • 3
  • 4
  • 5
 


Offline project ideas
Super Moderator
******
10,002 posts

Database Management System (DBMS)

[27435]

DBMS contains information about a particular enterprise
Collection of interrelated data
Set of programs to access the data
An environment that is both convenient and efficient to use
Database Applications:
Banking: all transactions
Airlines: reservations, schedules
Universities: registration, grades
Sales: customers, products, purchases
Online retailers: order tracking, customized recommendations
Manufacturing: production, inventory, orders, supply chain
Human resources: employee records, salaries, tax deductions
Databases touch all aspects of our lives


Purpose of Database Systems

In the early days, database applications were built directly on top of file systems
Drawbacks of using file systems to store data:
Data redundancy and inconsistency
Multiple file formats, duplication of information in different files
Difficulty in accessing data
Need to write a new program to carry out each new task
Data isolation — multiple files and formats
Integrity problems
Integrity constraints (e.g. account balance > 0) become “buried” in program code rather than being stated explicitly
Hard to add new constraints or change existing ones


Instances and Schemas


Similar to types and variables in programming languages
Schema – the logical structure of the database
Example: The database consists of information about a set of customers and accounts and the relationship between them)
Analogous to type information of a variable in a program
Physical schema: database design at the physical level
Logical schema: database design at the logical level
Instance – the actual content of the database at a particular point in time
Analogous to the value of a variable
Physical Data Independence – the ability to modify the physical schema without changing the logical schema
Applications depend on the logical schema
In general, the interfaces between the various levels and components should be well defined so that changes in some parts do not seriously influence others.


Data Manipulation Language (DML)


Language for accessing and manipulating the data organized by the appropriate data model
DML also known as query language
Two classes of languages
Procedural – user specifies what data is required and how to get those data
Declarative (nonprocedural) – user specifies what data is required without specifying how to get those data
SQL is the most widely used query language
Quote this message in a replyQuote
Offline engineering project helper
Moderator
*****
8,860 posts

DATABASE MANAGEMENT SYSTEMS


[38262]

History

IBM Sequel language developed as part of System R projects at the IBM San Jose Research Laboratory
Renamed Structured Query Language (SQL)
ANSI and ISO standard SQL:
SQL-86
SQL-89
SQL-92
SQL:1999 (language name became Y2K compliant!)
SQL:2003
Commercial systems offer most, if not all, SQL-92 features, plus varying feature sets from later standards and special proprietary features.
Not all examples here may work on your particular system.

Data Definition Language

The schema for each relation, including attribute types.
Integrity constraints
Authorization information for each relation.
Non-standard SQL extensions also allow specification of
The set of indices to be maintained for each relations.
The physical storage structure of each relation on disk.

Domain Types in SQL

char(n). Fixed length character string, with user-specified length n.
varchar(n). Variable length character strings, with user-specified maximum length n.
int. Integer (a finite subset of the integers that is machine-dependent).
smallint. Small integer (a machine-dependent subset of the integer domain type).
numeric(p,d). Fixed point number, with user-specified precision of p digits, with n digits to the right of decimal point.
real, double precision. Floating point and double-precision floating point numbers, with machine-dependent precision.
float(n). Floating point number, with user-specified precision of at least n digits.
More are covered in Chapter 4.

Tuple Variables

Tuple variables are defined in the from clause via the use of the as clause.
Find the customer names and their loan numbers and amount for all customers having a loan at some branch.

Conceptual Evaluation Strategy

Semantics of an SQL query defined in terms of the following conceptual evaluation strategy:
Compute the cross-product of relation-list.
Discard resulting tuples if they fail qualifications.
Delete attributes that are not in target-list.
If DISTINCT is specified, eliminate duplicate rows.
This strategy is probably the least efficient way to compute a query! An optimizer will find more efficient strategies to compute the same answers.
Quote this message in a replyQuote



Marked Labels: presentation topics for dbms, data replication in dbms seminar topic, dbms topics for seminar presentation, seminar topics database management system, seminar topics on dbms, seminar topics on database management system, seminar topics in database management system, pdf file for seminar topics on database management system, latest seminar topics on database management, seminar topic database management with sensor pdf file, seminar on data redundancy in dbms, seminar topics for database management system, seminar on overall structure of dbms, management system seminar topics, seminar topic on dbms, dbms seminar, seminar topics of database management systems,

[-]
Quick Reply
Message
Type your reply to this message here.


Image Verification
Image Verification
(case insensitive)
Please enter the text within the image on the left in to the text box below. This process is used to prevent automated posts.

Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  Vehicle Black Box System project source code cheker 1 273 18-03-2014 11:35 PM
Last Post: Guest
  Prepaid Electricity billing system using GSM technique seminar topic helper 14 12,468 13-03-2014 09:37 PM
Last Post: Guest
  EXAMINATION MANAGEMENT SYSTEM academic expert 8 7,853 09-02-2014 08:48 AM
Last Post: [email protected]
  distributed database full report best project report maker 7 4,515 13-09-2013 10:11 AM
Last Post: report maker
  TELEPHONE DIRECTORY MANAGEMENT project ideas 2 412 21-08-2013 11:20 AM
Last Post: report maker
  Real Time Embedded System Report engineering project helper 2 294 16-08-2013 12:44 PM
Last Post: report maker
  A Privacy-Preserving Location Monitoring System for Wireless Sensor Networks fine project uploader 2 735 25-05-2013 12:27 PM
Last Post: report maker
  NYMBLE BLOCKING SYSTEM PPT project source code cheker 1 892 14-05-2013 11:18 AM
Last Post: Guest
  Automated Examination Management System for Community Colleges ppt project source code cheker 2 684 12-03-2013 09:39 PM
Last Post: Guest
  Transaction Management PPT engineering project helper 1 231 29-01-2013 04:53 PM
Last Post: engineering project helper



User(s) browsing this thread: 1 Guest(s)