Answered step by step
Verified Expert Solution
Question
1 Approved Answer
normalize tables to 3nf CREATE TABLE Privilegee( P_number INT NOT NULL, Pname VARCHAR(30) NOT NULL, loan_period VARCHAR(30) NOT NULL, max_item INT, max_renewal INT, PRIMARY KEY
normalize tables to 3nf
CREATE TABLE Privilegee( P_number INT NOT NULL, Pname VARCHAR(30) NOT NULL, loan_period VARCHAR(30) NOT NULL, max_item INT, max_renewal INT, PRIMARY KEY (P_number)) Table created. CREATE TABLE LibraryItems( 1_number INT NOT NULL, Availability_VARCHAR(3) NOT NULL, PRIMARY KEY (1_number) ) Table createdStep 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