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.

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

MV vs DATAF

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.
while..
A variable is a place to store a piece of information. Just as you might store a friend's phone number in your own memory, you can store this information in a computer's memory. Variables are your way of accessing your computer's memory.

My Contrast

　 Data Data is raw material & unorganized facts that need to be processed . Information When data are processed, organized, structured or presented in a given context so as to make them useful, they are called Information. Data are plain facts. The word "data" is plural for "datum." When data are processed, organized, structured or presented in a given context so as to make them useful, they are called Information. It is not enough to have data (such as statistics on the economy). Data themselves are fairly useless. But when these data are interpreted and processed to determine its true meaning, they becomes useful and can be called Information. Data is the computer's language. Information is our translation of this language. Operating System The most important program that runs on a computer. Every general-purpose computer must have an operating system to run other programs. Operating systems perform basic tasks, such as recognizing input from the keyboard, sending output to the display screen, keeping track of files and directories on the disk, and controlling peripheral devices such as disk drives and printers. 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. Data storage 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. Computer storage an electronic memory device; "a memory and the CPU form the central part of a computer to which peripherals are attached"