Friday, August 14, 2009

My_Idea_Is

Part 2
A. Discuss what you have learned and understood about what relational
Database Management System is,so far.

DBMS is a software used to store some kind of data.It has many ways and has a big storage.A storage and bodega for all kinds of data.For business affairs,accounting and customizing.It is system where you can apply some applications needed.Always maintains data as where you saved it.It is more compatible for tables,record and query.Responsible for the user itself.


B.Define how each of the following fit and function within theframework of relational DBMS systems.

1.DATA FIELD-where you can store or put all the data needed.Like name,age,address,etc.
Defines what you have stored.It contains data to be entered as well as data to be displayed.

2.FORMS-to build a user friendly intrface of the user.

3.FOREIGN KEY-defines the most important things anywhere in the table. Indicating that the two records are related .

4.QUERIES-arranges the file alphabetically.

5.DATA TYPES-is a set of values and the operations on those values.

6.RECORDS-is one of the simplest data structures, consisting of two or more values or variables stored in consecutive memory positions; so that each component (called a field or member of the record) can be accessed by applying different offsets to a single physical address.

7.RELATIONSHIP(TABLE LINKAGES)- Linkage between tables occurs typically via some numeric identifier (ID) field that often is indexed to facilitate processing by the database software. Fields that function as table linkage IDs are necessary features of database design.