All Projects → victorst79 → PL-SQL-project

victorst79 / PL-SQL-project

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

Projects that are alternatives of or similar to PL-SQL-project

arangodb-net-core
DotNetCore ArangoDB Driver
Stars: ✭ 15 (-21.05%)
Mutual labels:  library-database
localdb
library to help you create database on local memory, support json local database inspired by lowdb
Stars: ✭ 35 (+84.21%)
Mutual labels:  library-database
Google-Apps-Script-Library-Database
This is for the Google Apps Script Library Database and a web application for searching the libraries..
Stars: ✭ 51 (+168.42%)
Mutual labels:  library-database
Android-Library-Management
Android Library Management Project
Stars: ✭ 32 (+68.42%)
Mutual labels:  library-database

PL-SQL-project

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

Normalization

  • CARD (Number, Fines, Status)
  • CUSTOMER (ID, Name, Address, Phone_number, Card_number [References CARD(Number)], Password, User_name, Date_sign_up)
  • EMPLOYEE (ID, Name, Address, Phone_number, Card_number [References CARD(Number)], Password, User_name, Paycheck, Branch_name [References BRANCH(Name)])
  • BRANCH (Name, Address [References LOCATION(Address)], Phone_number)
  • LOCATION (Address)
  • RENT (Card_ID [References CARD(Number)], Item_ID [References BOOK or VIDEO(ID)], Date, Return_date)
  • BOOK (ISBN, ID, State, Avalability, Deby_cost, Lost_cost, Address [References LOCATION(Address)])
  • VIDEO (Title, Year, ID, State, Avalability, Deby_cost, Lost_cost, Address [References LOCATION(Address)])
Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].