Course Hero Logo

013BSCCSIT026.docx - 1.ii Reduced application development...

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 3 out of 8 pages.

1.iiReduced application development time.Increase speed of implementing applications: Applications ought to be implemented in less time, sincesystems development staff can largely concentrate on the processes involved in the application itselfrather than on the collection, validation, sorting and storage of data. Much of the data required for anew application may already be held on the database, put there for another purpose. Accessing thedata will also be easier because the data manipulation features of the database management systemwill handle this.2. COMPONENTS OF DATABASE SYSTEMA database system is composed of four components:• Data• Hardware• Software• Userswhich coordinate with each other to form an effective database system.Fig. 1.1 Data Base System
User Data-It consists of a table(s) of data called Relation(s) where Column(s) are calledfields of attributes and rows are called Records for tables. A Relation must be structuredproperly.Metadata-A description of the structure of the database is known as Metadata. It basicallymeans "data about data". System Tables store the Metadata which includes.- Number of Tables and Table Names- Number of fields and field Names- Primary Key FieldsApplication Metadata-It stores the structure and format of Queries, reports and otherapplications components.2. Hardware-The hardware consists of the secondary storage devices such as magneticdisks (hard disk, zip disk, floppy disks), optical disks (CD-ROM), magnetic tapes etc. onwhich data is stored together with the Input/Output devices (mouse, keyboard, printers),processors, main memory etc. which are used for storing and retrieving the data in a fast andefficient manner. Since database can range from those of a single user with a desktopcomputer to those on mainframe computers with thousand of users, therefore proper careshould be taken for choosing appropriate hardware devices for a required database.3. Software-The Software part consists of DBMS which acts as a bridge between the userand the database or in other words, software that interacts with the users, applicationprograms, and database and files system of a particular storage media (hard disk, magnetictapes etc.) to insert, update, delete and retrieve data. For performing these operations such asinsertion, deletion and updation we can either use the Query Languages like SQL, QUEL,Gupta SQL or application softwares such as Visual 3asic, Developer etc.

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 8 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
NoProfessor
Tags
Relational model, Database model

Newly uploaded documents

Show More

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture