Assignment

Advance Java:

             

             1) Bean Concepts

             2) Events in Bean

Database Management System:

  

           1) Draw the E-R Diagram for the database of Departmental Store.

                 2) Using the details  given below,Create Table with DDL and DML commands.

                 Employee(e_no, name , address)
                 Department(d_name)
                 work_in(e_no, d_name)
                 looking_after(d_name, e_no) {manager}
                 item(internal_item_no, brand_name , model_no ,                      cost_price, sale_price)
                 Sale(d_name, internal_item_no)
                 Suppliers(s_name, s_address)
                 Supplied_by(internal_item_no,s_name)
           

           3) Construct an E-R diagram for a car company with set of customers each of which Owns a number of cars. Each car has a No. of recorded accidents associated with it.

           4) Construct an E-R diagram for the database of a Hospital with a set of patients and set of medical Doctors with each patients. A log of various test conducted is also associated.