DBMS LAB 1

-


1. Database Schema for a customer-sale scenario

Customer(Cust id : integer, cust_name: string)
Item(item_id: integer, item_name: string, price: integer)
Sale(bill_no: integer, bill_data: date, cust_id: integer,  item_id: integer, qty_sold: integer)

For the above schema, perform the following—
a)   Create the tables with the appropriate integrity constraints
b)   Insert around 10 records in each of the tables
c)   List all the bills for the current date with the customer names and item numbers
d)   List the total Bill details with the quantity sold, price of the item and the final amount
e)   List the details of the customer who have bought a product which has a price>200
f)    Give a count of how many products have been bought by each customer
g)   Give a list of products bought by a customer having cust_id as 5
h)   List the item details which are sold as of today
i)    Create a view which lists out the bill_no, bill_date, cust_id, item_id, price, qty_sold, amount
j)    Create a view which lists the daily sales date wise for the last one   week

Comments

Post a Comment

Popular posts from this blog

PROCEDURE TO CREATE AN ANIMATION TO REPRESENT THE GROWING MOON.

-
Image
1.       Open flash 8 software -> click on flash document ->go to windows->properties ->select the properties tool-> choose the Background to black. 2.       Go to fill color under tool bar-> select the white color. 3.       Select the oval tool in order to draw the moon. u will get a white circle. 4.       Select the oval tool in order to draw the moon. u will get a white circle. 5.       Select the white circle on the worksheet using the selection tool ->right click- >convert to symbol ->select movie clip ->give suitable name e g: moon->click ok. 6.       Go to filter ->click on the + symbol->select glow to apply glowing effect-> select the color to white under glow and adjust the blur x/blur y values. 7.       Click on the...
Read more

PROCEDURE TO CREATE AN ANIMATION TO INDICATE A BALL BOUNCING ON STEPS.

-
Image
1.     Go to start- macromedia- click on flash document 2.     Select the line tool and draw the steps. color it using the paint bucket tool 3.     Select the circle from the tool bar and create a circle on the work area. 4.     Now fill the color to the circle using the paint bucket tool from the tool bar. 5.     Go to frames right click on the first frame and choose insert key frame. Slightly move the ball. Repeat the same procedure by adding new key frames to show the ball change the shape of the ball slightly when it touches the surface. 6.     In order to change the shape use the free transform tool. 7.     Go to control and click on test movies .you will observe the ball bouncing on steps.
Read more

PROCEDURE TO SIMULATE MOVEMENT OF A CLOUD.

-
Image
1.       go to start- macromedia- click on flash document 2.       create a blue background in layer 1 3.       Now insert a layer 2 and draw the clouds in this layer. 4.       in order to create the clouds, go to tool bar and select pencil option, draw the cloud in layer2 5.       fill the color to the cloud, right click on it- choose convert to symbol option- give the name as cloud 6.       select the movie clip option and click ok. 7.       Go to filter ->click on the + symbol->select glow to apply glowing effect-> select the colour to white 8.       under glow and adjust the blur x/blur y values. 9.       give the appropriate blur effect to the cloud. 10.   go to frames, insert key frame on both ...
Read more