Data base Implémentation

Data base Implémentation

[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."

Essay Writing Service
Affordable prices

You might be focused on looking for a cheap essay writing service instead of searching for the perfect combination of quality and affordable rates. You need to be aware that a cheap essay does not mean a good essay, as qualified authors estimate their knowledge realistically. At the same time, it is all about balance. We are proud to offer rates among the best on the market and believe every student must have access to effective writing assistance for a cost that he or she finds affordable.

Caring support 24/7

If you need a cheap paper writing service, note that we combine affordable rates with excellent customer support. Our experienced support managers professionally resolve issues that might appear during your collaboration with our service. Apply to them with questions about orders, rates, payments, and more. Contact our managers via our website or email.

Non-plagiarized papers

“Please, write my paper, making it 100% unique.” We understand how vital it is for students to be sure their paper is original and written from scratch. To us, the reputation of a reliable service that offers non-plagiarized texts is vital. We stop collaborating with authors who get caught in plagiarism to avoid confusion. Besides, our customers’ satisfaction rate says it all.

© 2022 Homeworkcrew.com provides writing and research services for limited use only. All the materials from our website should be used with proper references and in accordance with Terms & Conditions.

Scroll to Top