COMM 226 Lecture Notes - Lecture 6: Dbase, Microsoft Access, Mysql
18 Sep 2017
School
Department
Course
Professor
Document Summary
Intellectual property: form of creative endeavor protected through trademark, patent, copyright, industrial design, integrated circuit topography: documents, applications, audio files, video logs, etc. What is the purpose of a database: databases keep track of things with more than one theme, most ppl keep track of things with spreadsheets. It is a collection of tables plus relationships among rows in tables, plus special data, called metadata, that describe structure f database. In the past, databases existed that were not relational in format: relation: another formal name for a table is relation. What is a dbms, and what does it do: database application system: conists of forms, formatted reports, queries, application programs, each of these calls on the dbms to process the database tables. The database management system: program used to create, process and administer a database, no organization develops its own dbms, companies license dbms products from vendors, popular dbms products are db2 from ibm, access and sql server from.
