History of the Database

• ·         A relational database chart that is used to map the information from the entity relationship diagram – Table Instance Chart
• ·         The unique identifier for each row of data - Primary Key (unique +Identifier)
• ·         Links data in one table to the data in a second table by referring to the PK column in the second table – foreign key
• ·         Indicates if a column must contain a value - mandatory
• ·         Indicates if the value in the column is unique within the table. - Unique
• ·         Refers to the format and definition of the data in each column. – Data Type

1.      Complete the diagram by listing the important events in the evolution of the database. Draw a line from each event to the era in which it falls.

·         1960’s: Computers became cost effective for private companies, and storage capacity increases.

·         1970-72 – E.F. Codd proposes the relational model for databases, disconnecting the logical organization from the physical storage.

·         1976: P.Chen proposes the entity relationship model (ERM) for database design.

·         Early 1980’s: The first commercially available relational DB systems start to appear at  the beginning of 1980s with Orcale ver 2

·         Mid-1980s: structured query language becomes widely accepted standard

·         Early 1990s: industry trend changes Oracle survives many go away.

·         Mid 1990’s: www appears

·         Late 1990’s: Large investment in internet companies – helps tools-market boom in web/internet/DB connectors

·         Early 21^st Century: Solid growth of DB applications continues.

2. True or False: The Personal Digital Assistant (PDA) was an important historical contribution in database development and design. True

3. Name two important historical contributions in database development and design.

·         1970-72 – E.F. Codd proposes the relational model for databases, disconnecting the logical organization from the physical storage.

·         1976: P.Chen proposes the entity relationship model (ERM) for database design.

4. If Building the database is the third major task in the database development process, then what are the first two major tasks?

·         Analyze – ( gives ERD)

·         Design – (Gives Table Instance Chart)