1.) Explain the organization of data in relational databases in terms of tables, records (rows),
and fields (columns). Give an example of a table and specify its fields. Which field(s) would you
choose as the primary key of that table?
and fields (columns). Give an example of a table and specify its fields. Which field(s) would you
choose as the primary key of that table?
2.) Explain the purpose of a conceptual database model and describe the most common
method of creating one.
method of creating one.
3.) Explain the importance of determining relationships before establishing primary keys in the
design sequence.
design sequence.
4.) What is a relational database management system and how does it relate to a database
administrator.
administrator.
Categories:
