Computer Science 1032A/B Chapter Notes - Chapter Final: Reduced Cost, Mycin, Offshoring
salmonrabbit587 and 40047 others unlocked
28
COMPSCI 1032A/B Full Course Notes
Verified Note
28 documents
Document Summary
Form of creative endeavor that can be protected through a trademark, patent, copyright, industrial design, or integrated circuit topography. Content management: database management systems (dbms): effectively and efficiently storing. Presentation of content: content management system (cms): organizing documents. Relational database: easy to understand, relationships aren"t predefined, database can evolve as required, relationships are implied in the data. Tables/files + relationships among rows in tables + metadata. Relationships among records: primary keys: columns that identify unique row in tables. Each table has a key: foreign keys: primary keys from a different table, relational database: databases using tables, primary keys and foreign keys. Description of the structure of database: databases are self-describing (contain description of its content, metadata, data that describes data, makes databases more useful, makes databases easier to use. Program: creates database, processes database, administers database, licensed from vendors: (access, sql server, oracle etc. )