×
SET SOME GOALS. STAY QUIET ABOUT THEM. SMASH THE HELL OUT OF THEM. CLAP FOR YOUR DAMN SELF.
--Your friends at LectureNotes
Close

Note for Database Management System - DBMS By vijay kumar

  • Database Management System - DBMS
  • Note
  • JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY - JNTUH
  • Computer Science Engineering
  • 120 Views
  • 2 Offline Downloads
  • Uploaded 1 year ago
Vijay Kumar
Vijay Kumar
0 User(s)
Download PDFOrder Printed Copy

Share it with your friends

Leave your Comments

Text from page-2

About the course • Steven Roman, Access Database Design & Programming (3rd Edition), O’Reilly 2002 • Curtis D. Frye, Microsoft Office Access 2007 Plain & Simple, Microsoft Press 2007 • http://office.microsoft.com/en-us/access-help/# • http://office.microsoft.com/en-us/accesshelp/database-basicsHA010064450.aspx#BMpartsofadatabase 2

Text from page-3

Basics about a database? • A database is a structured collection of records. • Database Management System (DBMS) – – – – add, remove, update records retrieve data that match certain criteria cross-reference data in different tables perform complex aggregate calculation • Database consists of columns (attributes) and rows (records). • Databases versus spreadsheets – easy manipulation of data 3

Text from page-4

Single table database ISBN Title AuID AuName AuTel PubID PubName PubTel Price 0-99-999999-9 Emma 1 Austen 111-111-1111 1 Big House 123-456-7890 20.00 zł 0-91-335678-7 Faerie Queen 7 Spenser 777-777-7777 1 Big House 123-456-7890 17.00 zł 0-91-045678-5 Hamlet 5 Shakespeare 555-555-5555 2 Alpha Press 999-999-9999 20.00 zł 0-103-45678-9 Iliad 3 Homer 333-333-3333 1 Big House 123-456-7890 25.00 zł 0-555-55555-9 Macbeth 5 Shakespeare 555-555-5555 2 Alpha Press 999-999-9999 12.00 zł 0-55-123456-9 Main Street 10 Jones 123-333-3333 3 Small House 714-000-0000 23.00 zł 0-55-123456-9 Main Street 9 Smith 123-222-2222 3 Small House 714-000-0000 23.00 zł 0-12-333433-3 On Liberty 8 Mill 888-888-8888 1 Big House 123-456-7890 25.00 zł 0-321-32132-1 Balloon 2 Sleepy 222-222-2222 3 Small House 714-000-0000 34.00 zł 0-321-32132-1 Balloon 4 Snoopy 444-444-4444 3 Small House 714-000-0000 34.00 zł 0-321-32132-1 Balloon 11 Grumpy 321-321-0000 3 Small House 714-000-0000 34.00 zł 4

Text from page-5

Disadvantages of a single table database • • • • • Redundancy of data Problem with complex data Problems in updating in bulk (new phone number) Problems in adding incomplete data (new publisher) Problems in removing group of data (all books from the publisher) Solution: Relational Database Management System (RDBMS) • E.g. Microsoft Access 5

Lecture Notes