What to do and Learn how to do?
Group Exercise – Design database — 5 in every group
1. Reservation of tables in a restaurant
2. Reservation of Books in a library
three. Managing your cell phone deal with ebook with classes (pals, household, enterprise, and so on.)
four. Managing your loved ones tree with all particulars
5. Reservation of seats for a actuality present
6. Managing ads on your pals music efficiency
7. Managing examination timetable
eight. Managing your bills with classes (tutorial, sports activities, leisure, journey, and so on.)
9. Managing your appointments (your calendar)
10. Managing your paperwork (digi locker)
11. Managing Essential Occasions in your calendar (pals birthday, dad and mom marriage ceremony anniversary, renewal of auto insurance coverage, and so on.)
12. Managing company for an occasion (Ex: Inter Collegiate competitors particular company)
13. Managing contributors for a contest
14. Managing menu in a restaurant
15. Managing your exercise schedules
16. Managing your cell utilization
17. Planning an extended tour with pals
18. Managing a category attendance
What to do?
• Every group to organize a case examine report overlaying three components
• Which OS your group would select with deserves of the identical
• A minimal of three and a most of seven schema ought to be recognized for the Information base administration System. Present clearly the schema, establish all integrity guidelines resembling Major Key and Overseas key
• Which community mannequin you’d select and why?
Learn how to do?
• What kind of utility? – Cell App or Net utility
• Which Working System? Home windows/ Linux/ Android/ …
• Why this OS? : Who developed this, model particulars, benefits (deserves), variety of customers on the planet,
• Schema Design
• Determine Integrity Constraints
• 10 Queries that your DBMS can reply
• Mannequin, benefits, Why this mannequin?
• Abstract web page giving 10 necessary options of your system (product)
• Who will use this?
• How would you market this product ?
What ought to I submit?
1. Video Presentation -10 to 12 slides
2. Report with cowl Web page (in PDF) -10 to 15 pages
How Ought to I Submit?
• Every group chief ought to submit the Video presentation and Report in AUMS.
• Deadline for the submission :- On or earlier than 30th January 2022.
• Analysis weightage – 15 marks
• Presentation Video – 5 Marks
• Implementation (Schema Design, Question, Report)-10 Marks
Cowl Web page
Division of Laptop Science and Engineering 19CSE101 – Laptop Methods Necessities Case Examine: TITLE SHOULD COME HERE
Batch: 2021 -2025
Examine of a Case
What ought to I do and the way ought to I do it?
Design a database as a gaggle exercise (5 folks per group).
1. Making a reservation for a meal at a restaurant
2. E book Reservation in a Library
three. Utilizing classes to prepare your cell phone deal with ebook (pals, household, enterprise, and so on.)
four. Conserving observe of all the info in your loved ones tree
5. Seating reservations for a actuality present
6. Managing promoting on your buddies’ musical performances
7. Organizing examination schedules
eight. Utilizing classes to handle your spending (tutorial, sports activities, leisure, journey, and so on.)
9. Conserving observe of your appointments (your calendar)
10. Doc administration (digi locker)
11. Organizing Essential Dates in Your Calendar (pals birthday, dad and mom marriage ceremony anniversary, renewal of auto insurance coverage, and so on.)
12. Organizing occasion guests (Ex: Inter Collegiate competitors particular company)