Tài liệu Accp i7.1 sem 4 practical paper set2 developing enterprise applications with ejb

--- Final Examination Practical Question Paper Developing Enterprise Applications with EJB Semester: 4 Curriculum Code: 2101 Date: Duration: 1 Hour Total Marks: 25 Do not write on this question paper and return it to the Invigilator after the examination. 2101/ Sem4 Practical Paper 1/2 --- Developing Enterprise Applications with EJB Total Marks: [25.0] ‘DVDHome’ is a popular shop for the latest and oldest CD’s, DVD’s. The shop sells CD’s and DVD’s and also provides it on rent. The Shop is very much popular as it provides Best quality items on very reasonable rate. The Shop management has decided to develop a platform for buying or renting items using J2EE technologies. It will reduce length of the queue which stands for buying or renting CD’s and DVD’s. You as a member of the development team have been assigned task to develop a platform for the above as per the guidelines given below:  Only registered user should be allowed to buy or rent items.  A discount of 5% should be available for the customer, who buy or rent more than 5 items.  A fine of 100 Rs. should be charged if customer returns rented items after seven days.  Customer less than 18 years should not be allowed to buy or rent items without parental guidance. o You need to design an E-R diagram that reflects the above requirements. o Create three tables namely: ‘Cust_Details’, ‘CD_Details’, and ‘Booking_Details’.  The ‘Cust_Details’ table should contain fields like: ‘Cust_ID’, ‘Name,’ ‘Address’, ‘Phone’, and ‘Age’.  The ‘CD_Details’ table should contain fields like: ‘CD_DVD_ID’, ‘CD_DVD_Name’, ‘Artiest’ and ‘Parental_Guidance’.  The ‘Booking_Details’ table should contain fields like: ‘Booking_ID’, ‘Cust_ID’, ‘CD_DVD_ID’, ‘Booking_Date’ and ‘Price’. o After creating the tables generate entity beans from these tables. 2101/ Sem4 Practical Paper 2/2