Galleries keep information about artists, their names (which are unique), birthplaces, age and style of art. For each piece of artwork, the artist, the year it was made, its unique title, its type of art (e.g., painting, lithograph, sculpture, photograph), and its price must be stored. Pieces of artwork are also classified into groups of various kinds, for example, portraits, still lifes, works by Picasso, or works of the 19th century; a given piece may belong to more than one group. Each group is identified by a name (like those just given) that describes the group. Finally, galleries keep information about customers. For each customer, galleries keep that persons unique name, address, total amount spent in the gallery and the artists and groups of art that the customer tends to like. 1.create updatable and no-updatable view specification which are application for the problem(two views). 2.create semantic integrity constraints for the above tables(three semantic integirty constraints (pre-defined,pre-compiled and general constraint) 3.create individual and set oriented assertions for the above tables (one individual and one oriented assertions