Answered step by step
Verified Expert Solution
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
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 16Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started