[ad_1]
Access 1 Assignment
Data base Implémentation
25 Possible Points
Instructions:
Given the diagram (entities, relationships, and cardinalities) and the table below (at the end of the assignment ) the diagram, determine which tables the foreign keys go in and determine the primary key of the relationship table.
Then, create, in Access, non-redundant relational database in access to include:
Table Structure consistent with the information needs and database design issues. Tables and fields defined as suggested below and populated with limited data (< 3 records in each table will do, relationship tables may have more records).
Helpful Hints:
All table names should begin with “table” followed by the name (i.e. tblcash)
All attribute names and table names should contain no spaces
Choose appropriate data types for each attribute. Only numbers used in calculations should be given a “number” data type.
If you choose a data type of “text”, you need to change the field size to an appropriate length
Every table needs a primary key
All foreign keys need to have the same data type as the primary key, with one exception. If a primary key has an a “auto_number” data type, the foreign key should have a data type of a “number”
Create the tables (and enter data into your tables) with no foreign keys first (data reduction tables, followed by resource and agent tables, followed by event tables and then relationship tables)
After you create your tables, draw the relationship lines and enforce referential integrity.
Finally, each table needs to have a minimum of 3 rows of data entered each attribute. Make up appropriate information.
Table Name | Table Type | Primary Key(s) | Foreign Key(s) | Attributes |
Cash | Resource | Cash Account # | location | |
Service type | Resource | Service Name | Hourly Billing Rate | |
Service Engagement | Event | Invoice # | Total Charge Number of Employees | |
Cash Receipt | Event | RA # | ||
Employee | Agent | Employee SSN | Hourly Wage Rate Highest Degree | |
Client | Agent | Client # | Name | |
Cashier | Agent | SSN | Phone Number | |
Many-to-many | Employee time | |||
TOTAL |
[Button id=”1″]
[ad_2]
Source link
"96% of our customers have reported a 90% and above score. You might want to place an order with us."
