BRIEF Instructions on Using SALSA V. 2

 

Here’s how to create the STUDENT-COURSE-Grades database I tried to do in class.   I’m going to call the Grades object ENROLMENT because I think it will be less confusing.  There’s several different ways to do many of these steps.  For simplicity, I’ve shown only one.  This is slightly different if you are using Version 1.  Here’s a link to what the model should look like.

 

  1. Open SALSA J
  2. At the bottom of the Catalog window on the left, click Create.
  3. Make sure Object is selected and create three objects as follows:
    1. Type STUDENT, click Add
    2. Type COURSE, click Add
    3. Type ENROLMENT, click Add.
    4. Click Cancel to close the Create Object window.
  4. Move the object boxes around on the screen so they don’t overlap.
  5. Add attributes to the STUDENT object as follows:
    1. In the Catalog on the left, click Identifier-Numeric and drag it into the STUDENT object box. (This will ultimately be the primary key because it’s a unique identifier.)
    2. Now double-click the Identifier-Numeric attribute in the STUDENT object box and rename it StudentID.
    3. Click and drag Name from the Catalog and drag it into the STUDENT object box.
    4. Double-click Name and change it to StudentName.
    5. Drag Address and Phone from the Profile Manage into the STUDENT object
  6. Add attributes to the COURSE object as follows:
    1. Click and drag Identifier-Text from the Catalog to the COURSE object.  (This will be the primary key.)
    2. Double click Identifier-Text in the COURSE object box and rename it CourseID.
    3. Drag Name from the Catalog to the COURSE object box and rename it CourseName.  
  7. Create relationships between the STUDENT object and ENROLMENT object and between the COURSE object and ENROLMENT object as follows:
    1. Click the small square at the upper left of the STUDENT object box and drag it into the ENROLMENT object box.  When you drop it, a rectangle with STUDENT will appear in the Grades object and a rectangle with ENROLMENT will appear in the STUDENT object.
    2. Click the small square at the upper left corner of the COURSE object box and drag it into the ENROLMENT object box.  As before, when you drop it a rectangle with COURSE will appear in the ENROLMENT object, and a rectangle with ENROLMENT will appear in the COURSE object.
  8. Create a primary key for the ENROLMENT object as follows:
    1. Click the STUDENT rectangle in the ENROLMENT object to highlight it.
    2. Hold down the Shift key and click the COURSE rectangle to highlight it.
    3. Click Design and choose Group.
    4. Name the Group GradeID.
    5. Right click GradeID to see its properties and change it to a unique ID with minimum and maximum cardinalities of 1.
    6. Right click STUDENT and COURSE and make sure their minimum and maximum cardinalities are also 1 in the ENROLMENT object.
  9. Create a Grade attribute as follows (we’ll modify the Name attribute):
    1. Drag the Name attribute from the Catalog to the ENROLMENT object.
    2. Right click the Name object to see its properties.
    3. Change the name of Name to Grade.
    4. Change the length of the field to 1.
  10. If the cardinalities of the ENROLMENT relationship in the STUDENT object are not 0,1, then right click and set them.  Do the same for the ENROLMENT relationship in the COURSE object.
  11. Now you should be able to generate an Access database from this model.