INFS1602 Final: INFS1602 FINAL Chapter 5

• School: UNSW, UNSW Sydney
• Department: Information Systems
• Course: INFS1602
• Professor: All

Document Summary

Columns/fields: bytes are grouped into columns (e. g. stud_name) Table/file: a group of similar rows or records is called a table/file. Key: column or group of columns that identifies a unique row in a table. Foreign key: keys of a different table than the one in which they reside. Importance: helpful for development of new business initiative, ubiquitous, business is dynamic and information systems must adapt, build own database. Help people keep track of things/ multiple themes. Dbms: a program used to create, process, and administer a database. (licensed) Database application: collection of forms, reports, queries and application programs that serves as an intermediary between users and the database. Reformat database table data to make it more informative and easily updated. Provide security, maintain data consistency, and handle special cases. User"s (cid:271)ro(cid:449)ser (cid:272)onne(cid:272)ts o(cid:448)er the internet to a web computer to connect to a database server computer.