Database Systems  CMPT 308

Database Systems CMPT 308

Lab 1: PostgreSQL - 20 points



 

 

Instruc,ons                         1. Download PostgreSQL from http://www.postgresql.org and install it on your computer.

 

2.      Short essay: Data vs. Information - Select a database in use today (real or imagined) and identify the elements of “data” stored therein and describe how the database organizes the “data” into “information”. Give contrasting examples of “data” and “information” that illustrate the meaninglessness of “data” without context and organization. Talk about the value the “information” provides once the component data is given context.

 

3.      Short Essay: Data Models - BrieWly describe the hierarchical and network pre-relational data models. Explain their shortcomings in relation to the relational model. Considering this, what do you think of XML as a model for data storage?

 

Resources

PostgreSQL - http://www.postgresql.org
 

Installation guides - https://wiki.postgresql.org/wiki/Detailed_installation_guides
Submi3ng
Take a screen shot of the pgAdmin tool up and running on your computer. Be creative as
 
to how you will show that it’s on your computer. Submit the screen shot and your essays
 
as a PDF document. (Only PDFs will be accepted. Seriously.)
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Database Lab                                                  © 2001-2016 Alan G. Labouseur, All Rights Reserved                                                      Page 1? of 1?
Powered by