The first time you save a table, Access willĪsk you to name the table. You are finished adding attributes, you need to save the table by Symbol that now appears to the left of the attribute. This makes the attribute sid the primary key. Repeat steps 5–7 for each of the attributes in the sailor table.Click on the first row under "Field Name." Enter the attribute name in the cell, such as "sid."Ĭlick on the cell under "Data Type" and click on the arrow box to see a.Sailor's name must be text whereas her rating must be a number. Of information are the names of the attributes, "Field Name," and their The attributes (or columns) that make up the table. Click on the Create tab.ĭialog box (refer to figure 3.26 below) for entering information about Step 2: Create and Modify Tables (5 points per table for 15 points total) Double-click on the Project3.mdb that you downloaded in Step 1.They should be essentially the same, however.Į-mail your instructor or TA if you encounter difficulties. Note that steps may vary slightly depending on what version of MSĪccess you are using. Step 1: Open the Database in Access (10 points) Create a new database in Access named "BoatClub.".Part A: Implement the BoatClub Model in Access (40 points)įollow these steps to create the BoatClub database. Details for completing these objectives are outlinedīelow. This Entity-Relationship model, your objectives are to implement aĭatabase in Access, insert some data into the database, query theĭatabase with SQL, and extend the BoatClub ER model to satisfy a new In other words, theseĪre one-to-many relationships. Similarly, a boat can be allocated to many reservations, but only oneīoat is allocated to a particular reservation. Many reservations (*) but a reservation involves only a single sailor. In short, the model states that a sailor can make We can also see that a boat is "allocated" to a "Sailor" and "Reservation." Thus, we see that a sailor "makes" a The label "Makes" tells us how to read the relationship between Individually foreign keys, plus they are part of the primary key. The name of the boat (also painted on the bow) Table 3.24-Attributes of the Boat Entity AttributeĪ boat ID-each boat is assigned a unique ID (painted on the bow) On the right of figure 3.22 is the "Boat" entity. The sailor's rating, ranging from 1 (low) to 10 (high) Table 3.23-Attributes of the Sailor Entity AttributeĪ sailor-each sailor is assigned a unique ID On the left ofįigure 3.22 is the "Sailor" entity. Let's look at this diagram, piece by piece. While other notations could be used, we use UML because of its current The model is expressed in Universal Modeling Language (UML). The Entity-Relationship model shown in figure 3.22.įigure 3.22-Entity-Relationship Model of BoatClub We can model the twoĮntities "Sailors" and "Boats" and the relationship "Reservation" with Important relationship in this simple problem.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |