A. Discuss what you have learned and understood about what Database Management System is, so far.
=> As what i have learned about DBMS it is about building database for it. It is the one who is responsible for it and i have learned that database management system is the one who manage such as software, for example, data where in is stored or attached inside a structure, a database structure.
B. Define how each of the following fit and function with in the framework of relational DBMS.
*Data Fields- all area in a computer memory or monitor, screen, is a formation
such as character or no. can be entered or stored.
*Forms - allow us to build a user-friendly interface for our users.
*Foreign Key- used to create relationships between tables. Natural relationships
exist between tables in most database structures.
*Queries- allow us to view data in different ways.
*Records-it allow us to collect or a collection of related item of information, as a unit by
a computer
*Reports- allow us to format a data.
*Relationships (Table Linkages)- relations between the data that were sored in the table.
Thursday, August 13, 2009
Tuesday, July 7, 2009
normalisation
Normalization
is a systematic way of ensuring that a database structure is suitable for general-purpose querying and free of certain undesirable characteristics—insertion, update, and deletion anomalies—that could lead to a loss of data integrity.
is a systematic way of ensuring that a database structure is suitable for general-purpose querying and free of certain undesirable characteristics—insertion, update, and deletion anomalies—that could lead to a loss of data integrity.
Sunday, July 5, 2009
My Assignment
DATA TYPES
1. What are they?
a. A data type (or datatype) in programming languages is a set of values and the operations on those values.
2. What roles do they play in database?
a. They determine what kind of data will be processed or will become input.
3. 3 Database Management Systems Program
a. Visual FoxPro
Visual 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.
b. SQL
SQL (Structured Query Language) (pronounced /ˌɛskjuːˈɛl/)[1] 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".[2] and became the most widely used language for relational databases[3][4]
c. FoxPro
FoxPro 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.
Kinds of Data Types and Description
a. integer : In more common parlance, whole number; a number that has no fractional part.
b. floating-point : A number with a decimal point. For example, 3 is an integer, but 3.5 is a floating-point number.
c. character (text): Readable text
1. What are they?
a. A data type (or datatype) in programming languages is a set of values and the operations on those values.
2. What roles do they play in database?
a. They determine what kind of data will be processed or will become input.
3. 3 Database Management Systems Program
a. Visual FoxPro
Visual 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.
b. SQL
SQL (Structured Query Language) (pronounced /ˌɛskjuːˈɛl/)[1] 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".[2] and became the most widely used language for relational databases[3][4]
c. FoxPro
FoxPro 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.
Kinds of Data Types and Description
a. integer : In more common parlance, whole number; a number that has no fractional part.
b. floating-point : A number with a decimal point. For example, 3 is an integer, but 3.5 is a floating-point number.
c. character (text): Readable text
Wednesday, June 24, 2009
MV vs. DF
MEMORY VARIABLE
Memory variable files are a way to store the status of memory variables that are currently stored in memory and use them later in the same program. In computer programming, a variable is an identifier (usually a letter, word, or phrase) that is linked to a value stored in the system's memory or an expression that can be evaluated. For instance, a variable might be called "total_count" and contain a number
DATA FIELD
A data field is a place where you can store data. Commonly used to refer to a column in a database or a field in a data entry form or web form. An area in the main memory of the computer in which a data record is contained. A data field is the smallest subdivision of the stored data that can be accessed. A data field can be used to store numerical information such as price, count or a date or time, or even a data and time. A pair of data fields can be used in combination to hold a geo-spatial coordinate. Also, a data field can be used to hold a block of text. A data field takes up permanent storage within the data-store.
Memory variable files are a way to store the status of memory variables that are currently stored in memory and use them later in the same program. In computer programming, a variable is an identifier (usually a letter, word, or phrase) that is linked to a value stored in the system's memory or an expression that can be evaluated. For instance, a variable might be called "total_count" and contain a number
DATA FIELD
A data field is a place where you can store data. Commonly used to refer to a column in a database or a field in a data entry form or web form. An area in the main memory of the computer in which a data record is contained. A data field is the smallest subdivision of the stored data that can be accessed. A data field can be used to store numerical information such as price, count or a date or time, or even a data and time. A pair of data fields can be used in combination to hold a geo-spatial coordinate. Also, a data field can be used to hold a block of text. A data field takes up permanent storage within the data-store.
Tuesday, June 23, 2009
MyContrast
Computer storage
computer storage - an electronic memory device; "a memory and the CPU form the central part of a computer to which peripherals are attached" .
Data storage
Data storage can refer to:
· Computer data storage; memory, components, devices and media that retain digital computer data used for computing for some interval of time.
· Any data storage device; that records (stores) or retrieves (reads) information (data) from any medium, including the medium itself
Data
Data are pieces of information that represent the qualitative or quantitative attributes of a variable or set of variables. Data (plural of "datum") are typically the results of measurements and can be the basis of graphs, images, or observations of a set of variables. Data are often viewed as the lowest level of abstraction from which information and knowledge are derived.
Information
Information as a concept has a diversity of meanings, from everyday usage to technical settings. Generally speaking, the concept of information is closely related to notions of constraint, communication, control, data, form, instruction, knowledge, meaning, mental stimulus, pattern, perception, and representation.
Computer system
A complete, working computer. The computer system includes not only the computer, but also any software and peripheral devices that are necessary to make the computer function. Every computer system, for example, requires an operating system.
Operating system
Operating system (commonly abbreviated to either OS or O/S) is an interface between hardware and user; it is responsible for the management and coordination of activities and the sharing of the resources of the computer. The operating system acts as a host for computing applications that are run on the machine. As a host, one of the purposes of an operating system is to handle the details of the operation of the hardware. This relieves application programs from having to manage these details and makes it easier to write applications. Almost all computers (including handheld computers, desktop computers, supercomputers, video game consoles) as well as some robots, domestic appliances (dishwashers, washing machines), and portable media players use an operating system of some type. [1] Some of the oldest models may however use an embedded operating system, that may be contained on a compact disk or other data storage device.
computer storage - an electronic memory device; "a memory and the CPU form the central part of a computer to which peripherals are attached" .
Data storage
Data storage can refer to:
· Computer data storage; memory, components, devices and media that retain digital computer data used for computing for some interval of time.
· Any data storage device; that records (stores) or retrieves (reads) information (data) from any medium, including the medium itself
Data
Data are pieces of information that represent the qualitative or quantitative attributes of a variable or set of variables. Data (plural of "datum") are typically the results of measurements and can be the basis of graphs, images, or observations of a set of variables. Data are often viewed as the lowest level of abstraction from which information and knowledge are derived.
Information
Information as a concept has a diversity of meanings, from everyday usage to technical settings. Generally speaking, the concept of information is closely related to notions of constraint, communication, control, data, form, instruction, knowledge, meaning, mental stimulus, pattern, perception, and representation.
Computer system
A complete, working computer. The computer system includes not only the computer, but also any software and peripheral devices that are necessary to make the computer function. Every computer system, for example, requires an operating system.
Operating system
Operating system (commonly abbreviated to either OS or O/S) is an interface between hardware and user; it is responsible for the management and coordination of activities and the sharing of the resources of the computer. The operating system acts as a host for computing applications that are run on the machine. As a host, one of the purposes of an operating system is to handle the details of the operation of the hardware. This relieves application programs from having to manage these details and makes it easier to write applications. Almost all computers (including handheld computers, desktop computers, supercomputers, video game consoles) as well as some robots, domestic appliances (dishwashers, washing machines), and portable media players use an operating system of some type. [1] Some of the oldest models may however use an embedded operating system, that may be contained on a compact disk or other data storage device.
Subscribe to:
Posts (Atom)