for professionals

hello all

i found some difficulties in this phase of this project may you please help me to accomplish it. try any part you think it is easy .the difficult points i face are are:

3. Image Field: In the ITEMS table, where a user will store the image file, the datatype should be properly declared.
(HERE YOU CAN USE SQL LOADER OR JAVA TO LOAD THE IMAGE THE IMAGE IS SMALL IN SIZE)

4.Creating the Constraints
d.Check Constraints - > Create suitable Check constraints on columns to check the values with some conditions.
e.Unique Constraints - > Create Unique constraints on columns that you decide that they cannot be primary key but should be unique.
5.Creating Views
a.Create 2 views. Views are used for the reporting purpose.
i.View Summary view – which include a detailed report of all the items which are sold, month-wise.
ii.View2 – Create a view which item is the one which is most sold and the least sold.
6.Create Sequence
a.This will be used to give the SELLER, a ADNO, with this number he can monitor the list of items which he is selling.
7.Write a trigger which can automatically update the status of the item as “NOT ACTIVE ” after 3 weeks of time. After this the item is not be listed on the ACTIVE list on the web.



Security Issues

Tasks Involved:

Consider CLASS01 as the SELLER. So GRANT him the proper privilege/permissions on your tables such that he can access the tables properly.

i hope to get some advice from you

thank you