create database; save as a02p1books lastnamefirstname · copyright © 2013 pearson education, inc....
Post on 12-May-2020
10 Views
Preview:
TRANSCRIPT
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Create database; save as a02p1books_LastnameFirstname
Create Author table as described, adding ID field, numbers 11-17 in Field1, last names in Field2, and first names in Field3
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Change the properties of fields as described
Delete ID field from table, make AuthorID the primary key
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Import Publishers worksheet into database as described
Import Books worksheet into database as described
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Modify properties of the Books table as specified
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Modify properties of the Publishers table as specified
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Create relationship between Author and Books tables; enforce referential integrity and Cascade Update Related Fields
Create relationship between Publishers and Books tables; enforce referential integrity and Cascade Update Related Fields
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
View and Close Relationships Report
Compact & Repair database
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
Backup database, save as a02p1books_LastnameFirstname_date
top related