×
Every problem might not have a solution right now, but don’t forget that but every solution was once a problem.
--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
  • 161 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-1

Databases for beginners 02-DBBA Marek Kręglewski 1

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

Lecture Notes