Mô tả:
---
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
- Xem thêm -