Database Management Systems ISYS 464. Fall 200 6 David Chao. Introduction to Databases. The most important component in an information system Created to support all levels of business operations: Day-to-day operations TPS, CRM, ERP Decision-makings DSS Strategic plans. Definitions.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Database Management Systems ISYS 464
Dim fileNumber, stCounter As Integer
Dim SID, SNAME As String
Dim gpa, sumGpa As Double
fileNumber = FreeFile()
FileOpen(fileNumber, "c:\stdata.txt", OpenMode.Input)
Do While Not EOF(fileNumber)
sumGpa += gpa
stCounter += 1
MessageBox.Show(sumGpa / stCounter.ToString)
DBMS manages data resources like an operating system manages hardware resources
Figure 2-7 Three-schema architecture
Different people have different views of the database…these are the external schema
The internal schema is the underlying design and implementation
1. Presentation – user interface
2. Processing logic
Database Server: A high processing power computer with advanced DBMS.
Client: A PC that runs database applications.
Figure 2-9 Three-tiered client/server database architecture
Prototyping Database Methodology(Figure 2.6)