HomeworkLib
Question

3. Use the Access tionship report for the Regional Books database shown in Figure 11-35 answer the following: a Identify the foreign keys in the Book table. purpose of the Book order table? c. What is the primary key of the Book Order table? d. Identify the foreign keys in the Book order table? Reintenahlpr for Regional soaks Thursday, Aan 12, 202


engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

3

a. Foreign keys in Book Table

  • AuthorNumber References Author(AuthorNumber)
  • BookCode References BookOrder(BookCode)

b. The BookOrder table is used for storing the order placed by a Customer for a Book

c. BookOrder table has composite PrimaryKey(BookCode,CustomerNumber)

d. Foreign keys in the BookOrder Table

  • BookCode References Book(BookCode)
  • CustomerNumber References Customer(CustomerNumber)
0 0
Add a comment
Know the answer?
Add Answer to:
Use the Access Relationship report for the Regional Books database shown in Figure 11-35 to answer...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • QUESTION 1 What is the most common relationship within a relational database? Select the best answer...

    QUESTION 1 What is the most common relationship within a relational database? Select the best answer from the following. One-To-One relationship. o One-To-Many relationship. Many-To-Many relationship. Zero-To-Zero relationship. QUESTION 2 What is an "entity'? Select the best answer from the following. An entity, for our purposes, is the same as a table in the database. An entity represents one of the columns in an individual table. There are no entities in a relational database. Entities are only part of NoSQL...

  • For a database of books in the bookstore, the __________ serves as the primary key (a)...

    For a database of books in the bookstore, the __________ serves as the primary key (a) Library of Congress code (b) Book publication date (c) Publisher’s zipcode (d) ISBN (e) none of the above When organizing data in a special order, the first step is to determine ____. (a) the sort keys (b) the sort order (c) if sorting is required (d) the restrictions (e) all of the above

  • Question 4 To represent a one-to-many relationship in a relational database design, _____. Group of answer...

    Question 4 To represent a one-to-many relationship in a relational database design, _____. Group of answer choices the key of the child is placed as a foreign key into the parent the key of the parent is placed as a foreign key into the child an intersection table must be created the key of the table on the "many" side is placed in the table on the "one" side the keys of both tables are joined into a composite key...

  • Describe briefly a database application case of your choice and represent your data in terms of...

    Describe briefly a database application case of your choice and represent your data in terms of 3 linked (via foreign key/s) tables. List their respective primary key and foreign key/s if any. Your database application case should be different from those already covered in the lectures or practicals. For the database case in the Additional Exercises of the previous practical, complete the proper construction of all the 5 tables in SQL, building all the pertinent primary and foreign keys there....

  • Use the following narrative to complete the UML class diagram with classes, associations, and multiplicities outlined...

    Use the following narrative to complete the UML class diagram with classes, associations, and multiplicities outlined below and then answer questions : The Multnomah County Library provides a variety of services to citizens of the county. First, the library offers a number of traditional books to be checked out by patrons. Each patron may check out up to 5 books at one time. Although library services are offered to all county citizens, each patron must obtain a library card to...

  • Write the following SQL statements in Microsoft Access by using the Books database from Week 2...

    Write the following SQL statements in Microsoft Access by using the Books database from Week 2 Assignment 2. Once complete, copy and paste the SQL statements in a Microsoft Word document: Write SQL statements: To update the publisher name from READ WITH US to READ FOR US To verify the updated name field for the publisher with ID 6 To make the following updates to the Publisher table (be careful with WHERE): Make Contact="John Travolta" for publisher with ID number...

  • Topic: Inventory Manangement Part A. Database Creation Your database should have a minimum of 4 tables...

    Topic: Inventory Manangement Part A. Database Creation Your database should have a minimum of 4 tables and include both one-to-many and many-to-many relationships. Be sure to include some numeric and/or date fields. Define all appropriate constraints, using the proper naming conventions (see Structure Notes below). Populate your database with at least 30 records in the main table(s), and whatever is needed in related tables. Submit the following: • a short description of the purpose of the database and what the...

  • Label the elements of the Access window shown in FIGURE 10-23. FIGURE 10-23 | All Access...

    Label the elements of the Access window shown in FIGURE 10-23. FIGURE 10-23 | All Access Obje « Match each term with the statement that best describes it. 9. Database 10. Object 11. Form 12. Record 13. Table 14. Field a. One row of data in a database table b. Information about one item in a particular record in a database c. An app component, such as a table or form that is saved in a database d. A collection...

  • Is about Access 2016 15) Access does not allow the creation of formulas for computation.           ...

    Is about Access 2016 15) Access does not allow the creation of formulas for computation.               a) True               b) False 16) The columns of a table corresponds to               a) Field               b) Record               c) Folder               d) File 17) An Access data base can contain a maximum of              a) any number of the table              b) Four              c) Ten              d) Twenty five 18) Which of the following is true about creating Access 2016 Table....

  • 6. With respect to database systems, which of the following statement(s) is (are) true? a. The...

    6. With respect to database systems, which of the following statement(s) is (are) true? a. The physical view of data is how people conceptually organize and understand the relationships among data items. b. The DML builds the data dictionary, creates the database, describes logical views for each user, and specifies security constraints. c. A record layout shows the items stored in a file, including the type of data stored and both the order and length of the data fields. d....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT