Dbms project final

Hosted for personal use

Transcript

1. Art Management System C S T 2 0 8 D A T A B A S E M A N A G E M E N T S Y S T E M L A B GUIDED BY, MS.R.PRIYAMBIGA, ASSISTANT PROFESSOR, AYUSH KUMAR , 19ST114281118 PRATIK GAIKWAD , 19ST114281025 SAKSHI LAMBE , 19ST11428049 ADITYA PATIL , 19ST114281074 AARYA PATIL , 19ST114281073 PREPARED BY,
2. To allow users to login to the system portal as customer, admin, etc. To allow users to explore paintings, sculptors or handicrafts exhibited on the website in the storage of the organizing gallery. To allow art galleries to showcase their collections online. To allow art galleries to keep a record of events being organized. To allow art galleries to keep a record of the total number and specifications of creations that they host, and its status. To allow art galleries to keep a record of art pieces being collected. To allow users to participate or register for upcoming events. To provide an online platform to manage the buying, selling and storage of artistic creations provided by creators/other platforms or auctions, and to organize events to exhibit these products. Objectives: PROBLEM STATEMENT
3. ER-Diagram
4. RELATIONAL SCHEMA
5. RELATIONAL SCHEMA
6. Table Details snapshot of tables with values
7. QUERIES DISPLAY THE NAMES OF ARTIST AND THE EXHIBITIONS THEY HAVE PARTICIPATED IN. select a_name from artist where a_id in(select a_id from participate) group by a_name DISPLAY DETAILS OF ARTISTS PARTICIPATING IN EXHIBITIONS HELD IN NEW YORK. select * from artist where a_id in (select a_id from participate where e_id in (select e_id from exhibition where location='New York')) FIND THE NAMES OF HANDICRAFTS BY A PARTICULAR ARTIST. select h_name from handicraft where a_id in(select a_id from artist where a_name='cao fei'); FIND THE ARTISTS WHO HAVE A SCULPTURE WHOSE PRICE IS MORE THAN 20000. select a_name from artist where a_id in(select a_id from sculpture where price >20000) group by(a_name);
8. THANK YOU !