PL / SQL Project based on a library's database.

• Customers(ID[PK],Name,Addres,Phone_Number,Date_SingninUp,User_Name,Password,Card)
• Book(ID[PK],ISBN,Lost_Cost,Delay_Cost,Location,Availability,State,Quantity)
• Video(ID[PK],Tittle,Age,Location,Lost_Cost,Delay_Cost,Availability,State,Quantity)
• Cards(ID[PK],Fines,State)
• Branch(Name[PK],Addres,Phone_Number,Media,Employees)
• Employees(ID[PK],Name,Addres,Phone_Number,User_Name,Password,Card,Paycheck)

• Book(ISBN, Quantity)
• Video(Title, Year, Quantity)
• BookCopy(ISBN [References Book], Item_ID [References Item])
• VideoCopy(Titulo, Año [References Video], Item_ID [References Item])
• Item(ID, Lost_Cost, Delay_Cost, Availability, State, Item_Type: boolean(Book-Video))
• Customer(ID, Name, Address, Phone_Number, Date_Sing_Up, User_Name, Password, Card_Number [References Card])
• Employee(ID, Name, Address, Phone_Number, User_Name, Password, Card_Number [References Card], Paycheck)
• Card(Number, Estado, Multas)
• Rent(Item_ID [References Item], Customer ID [References Item])
• Branch(Name, Address, Phone_Number, Media, Employee_ID [References Employee])