Form 1 Title: The Joy of E-R Modelling Published_In 2013 ISBN: 939757 Author Id: AU505 Author Name : Moss Author Id: Author Name: - CopyNo C1034 Shelf Number C100 DateAcquired: 12-APR-16 Borrower Id Borrower Name Borrower Dept Loan Date Return Date CIS 02-ОСТ-16 13-OCT-16 A12 Bloggs Greenacre 13-0ОСТ-16 27-ОСТ-16 B34 Business Form 2 Title: Normalisation is Fun and Easy Published_In 2010 ISBN: 549950 Author Id AU1911 Author Id AU505 Author Name :Bollinger Author Name : Moss CopyNo C2399 Shelf Number: C101 DateAcquired: 22-APR-2011 Borrower Id Borrower Name Borrower Dept Loan Date Return Date Greenacre Franks 18-OCT-16 29-OCT-16 B34 Business 04-ОСТ-16 L67 Leisure 22-ОСТ-16 Form 3 Title: Normalisation is Fun and Easy Published_In 2010 ISBN: 549950 Author Id AU1911 Author Name : Bollinger Author Id AU505 Author Name : Moss CopyNo C2400 Shelf Number: C101 DateAcquired: 25-JUN-2011 Borrower Dept Loan Date 04-ОСТ-16 02-SEP-16 Borrower Id Borrower Name Return Date A12 L67 Bloggs Franks CIS 25 ОСТ-16 Leisure 09-SEP-16
Form 1 Title: The Joy of E-R Modelling Published_In 2013 ISBN: 939757 Author Id: AU505 Author Name : Moss Author Id: Author Name: - CopyNo C1034 Shelf Number C100 DateAcquired: 12-APR-16 Borrower Id Borrower Name Borrower Dept Loan Date Return Date CIS 02-ОСТ-16 13-OCT-16 A12 Bloggs Greenacre 13-0ОСТ-16 27-ОСТ-16 B34 Business Form 2 Title: Normalisation is Fun and Easy Published_In 2010 ISBN: 549950 Author Id AU1911 Author Id AU505 Author Name :Bollinger Author Name : Moss CopyNo C2399 Shelf Number: C101 DateAcquired: 22-APR-2011 Borrower Id Borrower Name Borrower Dept Loan Date Return Date Greenacre Franks 18-OCT-16 29-OCT-16 B34 Business 04-ОСТ-16 L67 Leisure 22-ОСТ-16 Form 3 Title: Normalisation is Fun and Easy Published_In 2010 ISBN: 549950 Author Id AU1911 Author Name : Bollinger Author Id AU505 Author Name : Moss CopyNo C2400 Shelf Number: C101 DateAcquired: 25-JUN-2011 Borrower Dept Loan Date 04-ОСТ-16 02-SEP-16 Borrower Id Borrower Name Return Date A12 L67 Bloggs Franks CIS 25 ОСТ-16 Leisure 09-SEP-16
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
The university of Zimbabwe library holds a large stock of books that are available for loan to various borrowers. The library requires a database to support the processing of these loans. Examine the example records in the Forms (Figure 1) and the assumptions (Figure 2) shown below, then attempt the questions that follow:
Figure 1: Three sample forms recording loans of copies of books over a period of time
Figure 2: Assumptions made
1) Design a Database and create required tables
2) Apply the constraints like Primary Key , Foreign key, NOT NULL to the tables.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY