GWU OnLineNews Publishing Database Worksheet
Question Description
Instruction
Work with MS Access this week. Create three or more tables based on your design of OnLineNews Publishing database. Under “Database Tools” find Relationship view, add three tables according to you design of OnLineNews Publishing database schema to this view. Then establish a relationship by dragging from the Primary Key field in one table to the Foreign Key field in another table. Make sure that you select a checkmark”Enforce Referential Integrity” for making proper relationship between the tables.
After setting a relationship between tables, add 5 records of data to each of your three tables. Try to add a record with a FOREIGN KEY value that does not match a PRIMARY KEY value in another table.
What happens in this case? What error message do you get?
book
database_concepts_by_david_m._kroenke_david_auer_scott_l._vandenberg_robert_c._yoder.pdf
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."