Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a table naming Student on SQL Student ID(pk) Fname Lname Gender Age Contact address Student email Student password borrowing_lD (PK) book_lD (FK) stud_lD (FK)

Create a table naming Student on SQL

Student ID(pk) Fname Lname Gender Age Contact address Student email Student password

image text in transcribed

borrowing_lD (PK) book_lD (FK) stud_lD (FK) date_borrowed date_return Student stud_lD (PK) fname Iname gender age contact_add stud_email stud_pass Transaction trans_lD (PK) trans_name borrowing_lD (FK) stud_lD (FK) date Book book_lD (PK) bk_title bk_name publisher author bk num pub_date Reports report_lD (PK) trans_lD (FK) borrowing_lD (FK) report_date Users user_lD (PK) fname Iname gender contact_add user_email user_pass

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

Data Mining Concepts And Techniques

Authors: Jiawei Han, Micheline Kamber, Jian Pei

3rd Edition

0123814790, 9780123814791

More Books

Students also viewed these Databases questions

Question

=+d. Does it offer little phrases? If they work? Like this.

Answered: 1 week ago

Question

=+c. Does it use short, concise sentences?

Answered: 1 week ago