Preview of Database lab quiz
You are given two "flat files" from which you are to create a database
that relates the two files.
alpha.csv is a table of alphas.
beta.csv is a table of betas.
Each alpha relates to a single beta, but a beta may relate to multiple alphas. (For example, Student -> Dormitory, Rock climb -> Formation,
City -> County).
Each beta as a field that uniquely identifies it, and
each alpha record contains a field F indicating which beta they relate to.
Create a new application called "AlphaBeta". You may delete your Music
Database if you need to.
Import the first file into a form called "Alphas" and the second
file into a form called "Betas".
Create a relationship between the Alphas form and the Betas form
based on field F.
Use the Alpha view to edit the data and link each alpha record
to the correct beta. When finished, delete the F field.
Create a new combined view based on Alphas called Deltas.
This view displays the alphas fields 1,2, and 3
and also displays the fields 4,5,6 from their beta. Group the
results by Beta and sort the alphas by field 2. Display 20
records per page. Save
the changes to your view and share it with the instructor:
