My Assignment

A.) What are data type?

Data types are classifications that identify possible values for and operations that can be done on the data, as well as the way the data in that field is stored in the database.

• Access data types

*Object linking and embedding (OLE) objects are objects created in other applications that are linked or embedded in Access. In this case, binary large object (BLOB) and GEOMETRY data types don't exist in Access, so the object is in ArcGIS and linked to the Access database.

• DB2 data types
• Oracle data types
• PostgreSQL data types
• SQL Server data types

B.) What role do they play in a data base?

They determine what kind of data will be processed or will become input.

C.) Enumarate the data type at least 3 DBMS softwares:

1. Visual FoxProVisual FoxPro is a data-centric object-oriented and procedural programming language produced by Microsoft. It is derived from FoxPro (originally known as FoxBASE) which was developed by Fox Software beginning in 1984.
2. SQLSQL (Structured Query Language) (pronounced /ˌɛskjuːˈɛl/)is a database computer language designed for managing data in relational database management systems (RDBMS). Its scope includes data query and update, schema creation and modification, and data access control. SQL was one of the first languages for Edgar F. Codd's relational model in his influential paper, "A Relational Model of Data for Large Shared Data Banks".and became the most widely used language for relational databases
3. FoxProFoxPro is a text-based procedurally-oriented programming language and DBMS, originally published by Fox Software and later by Microsoft, for MS-DOS, MS Windows, Apple Macintosh, and UNIX.