Case Examine
What to do and How you can do?
Group Activity – Design database — 5 in each team
1. Reservation of tables in a restaurant
2. Reservation of Books in a library
three. Managing your cell phone deal with guide with classes (associates, household, enterprise, and so forth.)
four. Managing your loved ones tree with all particulars
5. Reservation of seats for a actuality present
6. Managing commercials in your associates music efficiency
7. Managing examination timetable
eight. Managing your bills with classes (educational, sports activities, leisure, journey, and so forth.)
9. Managing your appointments (your calendar)
10. Managing your paperwork (digi locker)
11. Managing Vital Occasions in your calendar (associates birthday, dad and mom wedding ceremony anniversary, renewal of auto insurance coverage, and so forth.)
12. Managing friends for an occasion (Ex: Inter Collegiate competitors particular friends)
13. Managing members for a contest
14. Managing menu in a restaurant
15. Managing your exercise schedules
16. Managing your cellular utilization
17. Planning an extended tour with associates
18. Managing a category attendance
What to do?
• Each team to organize a case examine report overlaying three elements
• Which OS your team would select with deserves of the identical
• A minimal of three and a most of seven schema ought to be recognized for the Knowledge base administration System. Present clearly the schema, determine all integrity guidelines similar to Main Key and International key
• Which community mannequin you’d select and why?
How you can do?
• What kind of software? – Cellular App or Net software
• Which Working System? Home windows/ Linux/ Android/ …
• Why this OS? : Who developed this, model particulars, benefits (deserves), variety of customers in the world,
• DBMS
• Schema Design
• Establish Integrity Constraints
• 10 Queries that your DBMS can reply
• Networks
• Topology
• 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?
• Each team 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 Pc Science and Engineering 19CSE101 – Pc Methods Necessities Case Examine: TITLE SHOULD COME HERE
Batch: 2021 -2025
Semester: 1
January 2022
——
Examine of a Case
What ought to I do and the way ought to I do it?
Design a database as a bunch exercise (5 folks per team).
1. Making a reservation for a meal at a restaurant
2. Ebook Reservation in a Library
three. Utilizing classes to arrange your cell phone deal with guide (associates, household, enterprise, and so forth.)
four. Conserving monitor of all the information in your loved ones tree
5. Seating reservations for a actuality present
6. Managing promoting in your buddies’ musical performances
7. Organizing examination schedules
eight. Utilizing classes to handle your spending (educational, sports activities, leisure, journey, and so forth.)
9. Conserving monitor of your appointments (your calendar)
10. Doc administration (digi locker)
11. Organizing Vital Dates in Your Calendar (associates birthday, dad and mom wedding ceremony anniversary, renewal of auto insurance coverage, and so forth.)
12. Organizing occasion guests (Ex: Inter Collegiate competitors particular friends)
13