MIS-401 || DBM || Class-07 || 13-01-26

🎓 Summary The video is a group presentation and discussion from an MIS-401 Database Management class. Students present Entity-Relationship (ER) diagrams and tables for different systems (bus ticketing, banking, mobile payment). They explain relationships between entities like passengers, tickets, payments, conductors, bank branches, customers, transactions, users, wallets, and merchants. The instructor frequently interrupts to correct misunderstandings about cardinality (one-to-one, one-to-many, mandatory vs. optional participation) and emphasizes proper ER modeling. Toward the end, the instructor outlines the course syllabus, covering topics such as relational algebra, normalization, anomalies, big data, NoSQL, cloud databases, and database engines. The session closes with students apologizing for earlier mistakes and the instructor clarifying exam expectations. Highlights 2:39 Bus Ticketing System ER Diagram Farzana Akhter Lopa introduces the project. Entities: passenger, bus, conductor, ticket, payment. Relationships: passenger–bus (many-to-one), ticket–payment (one-to-one). 5:47 Conductor–Ticket Relationship Discussion on whether conductor–ticket is one-to-many. Instructor clarifies conductor supervises multiple tickets and passengers. 9:19 Bank–Branch Relationship Students debate cardinality (one-to-many). Instructor stresses mandatory relationship: a branch must belong to a bank. 17:26 Mobile Payment System ER Diagram Sunny’s group presents user, wallet, merchant, and transaction entities. Relationships: user–wallet (one-to-one), user–bank account (one-to-many), merchant–payment (one-to-many). 34:11 Syllabus Overview Chapters: relational algebra, ER modeling, normalization, anomalies, big data, NoSQL, cloud databases. Instructor emphasizes practicing queries, normalization, and understanding anomalies. 47:35 Apology & Exam Clarification Students apologize for earlier mistakes and poor midterm performance. Instructor agrees to adjust participation marks and explains exam will focus on core questions with case variations.