Notes
Notes - notes.io |
clienti
client_id - number(9),primary key , generat auto increment
client_name- varchar(30),not null
cnp - varchar(13) ,not null,unique ,constrangere check length=13
credit card - number(16),not null,unique , constrangere check length=16
comenzi
client_id- number(9) ,not null, foreign key (clienti.client_id) din tabela clienti
id_comanda number(9) ,not null, primary key , generat prin autoincrement
prettotal number(9) - pretul total . se calculeaza in aplicatie ( urmeaza a fi implementat), default = 0
cos_cumparaturi
id_comanda- number(9) ,not null,foreign key(comenzi.id_comanda)
product_id- number(9),not null, foreign key(products.product_id)
cantitate- number(4) = cantitatea de produse cumparate
discount- number(2,2) = discountul pe toate produsele , constrangere check discount <0.5
produse
product_id- number(9) ,not null, primary key
category_id- number(9), not null, foreign key(categorie_produs.category_id)
product_name- varchar2(25), unique
cantitate- number(4) - nr de produse din stoc
pret- number(8) - pretul produsului
categorie_produs
category_id number(9),not null, primary key
cat_nam varchar2(30),unique,not null
relatii:
one to one intre clienti si comenzi (un client da o singura comanda)
one to many intre comenzi si cos cumparaturi (mai multe produse intr-o comanda)
one to many intre produse si cos cumparaturi (mai multe produse intr-un cos de cumparaturi)
one to many intre categorie produs si produse ( mai multe produse in aceiasi categorie);
aplicatie
permite vizualizarea, inserarea si stergerea de inregistrari
in cazul in care nu se respecta constrangerile se va afisa un mesaj de eroare iar inserarae nu se va efectua
o inregistrare trebuie introdusa intai in tabela parinte si apoi in tabela fiu si stearsa in sens invers
|
|
Notes is a web-based application for online taking notes. You can take your notes and share with others people. If you like taking long notes, notes.io is designed for you. To date, over 8,000,000,000+ notes created and continuing...
With notes.io;
- * You can take a note from anywhere and any device with internet connection.
- * You can share the notes in social platforms (YouTube, Facebook, Twitter, instagram etc.).
- * You can quickly share your contents without website, blog and e-mail.
- * You don't need to create any Account to share a note. As you wish you can use quick, easy and best shortened notes with sms, websites, e-mail, or messaging services (WhatsApp, iMessage, Telegram, Signal).
- * Notes.io has fabulous infrastructure design for a short link and allows you to share the note as an easy and understandable link.
Fast: Notes.io is built for speed and performance. You can take a notes quickly and browse your archive.
Easy: Notes.io doesn’t require installation. Just write and share note!
Short: Notes.io’s url just 8 character. You’ll get shorten link of your note when you want to share. (Ex: notes.io/q )
Free: Notes.io works for 14 years and has been free since the day it was started.
You immediately create your first note and start sharing with the ones you wish. If you want to contact us, you can use the following communication channels;
Email: [email protected]
Twitter: http://twitter.com/notesio
Instagram: http://instagram.com/notes.io
Facebook: http://facebook.com/notesio
Regards;
Notes.io Team
