Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

is it alright? Given the relation diagram of a library database here, answer the questions below e ISBN: char(13) BranchiD inti11) CardNo: varchar(9) DateOut date

image text in transcribed

image text in transcribed

is it alright?

Given the relation diagram of a library database here, answer the questions below e ISBN: char(13) BranchiD inti11) CardNo: varchar(9) DateOut date Duedate: date e CardNo varchar(9) Name varchar 32) Address: varchar(64) 16) BranchID: int(11) BranchName varchar(32) Address: varchar(64) e ISBN : char(13) BranchlD int11) u NumCopies int(11) ors e ISBN: char(13) Name: varchar(64) Address varchart64) Tite varchar 64) PublisherName: varchar(64) ISBN: char(13) AuthorName: varchar 32) Fil in the blanks with numbers instead of words, for example, 5 instead of five) 1The library database contains 7 tables 2. There are 4 tables with keys consist of only one field, 2tables with keys consist of exactly two fields, tables with keys consist of exactly three fields 3. The primary key in table publisher is referenced by 1 tables as their foreign keys 4. The primary key in table book authors contains 2 fields 5. The primary key in table book is referenced by 3tables as their foreign 16

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Concepts

Authors: David Kroenke

4th Edition

0136086535, 9780136086536

More Books

Students also viewed these Databases questions

Question

69 Needs assessment and analysis.

Answered: 1 week ago