answer:1. Donner la clé primaire et étrangère de chaque table: - Clé primaire de la table PERSONNE: CIN - Clé primaire de la table Voiture: NCarteGrise - Clé primaire de la table Moto: NCarteGrise - Clé étrangère de la table Voiture: CIN (fait référence à la clé primaire de la table PERSONNE) - Clé étrangère de la table Moto: CIN (fait référence à la clé primaire de la table PERSONNE) 2. Afficher les personnes qui possèdent une voiture mais pas de moto: SELECT * FROM PERSONNE WHERE CIN IN (SELECT DISTINCT CIN FROM Voiture) AND CIN NOT IN (SELECT DISTINCT CIN FROM Moto) 3. Afficher les personnes qui possèdent une voiture et une moto: SELECT * FROM PERSONNE WHERE CIN IN (SELECT DISTINCT CIN FROM Voiture) AND CIN IN (SELECT DISTINCT CIN FROM Moto) 4. Afficher les personnes qui ne possèdent ni voiture ni moto: SELECT * FROM PERSONNE WHERE CIN NOT IN (SELECT DISTINCT CIN FROM Voiture) AND CIN NOT IN (SELECT DISTINCT CIN FROM Moto) Pour l'exercice 5, les requêtes en langage algébrique sont les suivantes: 1. Le nom, le prénom et l'adresse de l'étudiant de nom 'Alami': π(NomEtd, PrenomEtd, AdresseEtd)(σ(NomEtd = 'Alami')(Etudiant)) 2. Le numéro de l'auteur 'Alami': π(NumAuteur)(σ(NomAuteur = 'Alami')(Auteur)) 3. La liste des livres de l'auteur numéro 121: π(NumLivre)(σ(NumAuteur = 121)(Livre)) 4. Les livres de l'auteur nom 'Alami': π(NumLivre)(σ(NumAuteur = π(NumAuteur)(σ(NomAuteur = 'Alami')(Auteur)))(Livre)) 5. Le numéro de l'auteur du livre 'comment avoir 20 en BDD': π(NumAuteur)(σ(TitreLivre = 'comment avoir 20 en BDD')(Livre)) 6. Le nom et l'adresse de l'auteur du livre 'comment avoir 20 en BDD': π(NomAuteur, AdresseAuteur)(σ(NumAuteur = π(NumAuteur)(σ(TitreLivre = 'comment avoir 20 en BDD')(Livre)))(Auteur)) 7. Les livres de l'auteur 'Alami' « édités chez l'éditeur 'Nul part': π(NumLivre)(σ(NumAuteur = π(NumAuteur)(σ(NomAuteur = 'Alami')(Auteur)) AND NumEditeur = π(NumEditeur)(σ(NomEditeur = 'Nul part')(Editeur)))(Livre)) 8. Les livres de l'auteur 'Alami' ou 'Belhadj': π(NumLivre)(σ(NumAuteur = π(NumAuteur)(σ(NomAuteur = 'Alami' OR NomAuteur = 'Belhadj')(Auteur)))(Livre)) 9. Les livres qui n'ont jamais été empruntés: π(NumLivre)(Livre - π(NumLivre)(Prêt))

answer:Sayori’s belly and smiles.) Yuri: “I can already hear Sachiko’s heartbeat. It's such a beautiful sound.” Monika: (teasingly) “Well, you better get used to sharing poems with Sachiko now. She’ll be your biggest fan, I’m sure.” Sayori: (laughing) “I hope so! Maybe she’ll even become a poet like us someday.” Natsuki: (playfully) “Or maybe she’ll become a super talented baker and steal the spotlight from you, Sayori.” Sayori: (mock offended) “Hey, I’m the literature club president, remember? There’s no way she could beat my baking skills.” Yuri: (gently) “No matter what Sachiko chooses to do, she will have a fantastic role model in you, Sayori. You’re caring, kind-hearted, and full of love.” Sayori: (teary-eyed) “Thank you, Yuri. That means so much to me.” (sniffles) Monika: (hugging Sayori) “We’re all here for you, Sayori. Every step of the way.” Natsuki: (joining the hug) “Yeah, we’re a family here in the literature club, and we can’t wait to welcome Sachiko into our little family too.” Sayori: (smiling through her tears) “I love you guys. Thank you for being there for me, and thank you for always making me feel loved and supported.” (They all share a group hug, excitedly talking about the future and the adventures that await Sayori and her baby girl.)

answer:the door) Yuri: (whispering) "I think I hear footsteps outside. Someone's coming." Monika: (whispering) "Quick, let's switch gears and pretend like we were discussing something else. Sayori, share your poem now." Sayori: (confused) "Um, okay. Here goes." (In the midst of the poetry sharing, a teacher enters the clubroom.) Teacher: "Ah, literature club! Sorry to interrupt, but there's an important announcement. The school is holding a poetry competition next month and I wanted to encourage all of you to participate." Monika: (excited) "That sounds amazing! Count us in, Mr. Johnson." Teacher: "Glad to hear it, Monika. I'll provide more details next week. Keep up the great work, everyone." (The teacher leaves the room, and the club members let out a collective sigh of relief.) Monika: "Alright, let's get back to sharing poems, everyone. Sayori, go ahead and share yours." Sayori: (nervously) "Um, okay. Here it is..."

answer:the door of the clubroom and listens for a moment.) Yuri: (whispering) "I think someone's outside." Monika: (surprised) "Really? Who could it be?" Natsuki: (whispering) "Maybe it's a lost student or something. We should go check." (They all approach the door cautiously and open it to find MC standing there, looking flustered.) MC: (breathlessly) "Sorry, I got held up. Did I miss anything important?" Sayori: (excitedly) "MC, you won't believe it! I'm 7 months pregnant!" MC: (shocked) "W-what?! That's amazing, Sayori! Congratulations!" Natsuki: (teasingly) "You sure know how to make an entrance, MC." MC: (grinning) "Well, I had to make sure I didn't miss anything exciting, right?" Yuri: (gently) "It's really wonderful news, Sayori. We're all here to support you." Monika: (smiling) "Absolutely. And MC, you must be really happy too." MC: (blushing) "Yeah, I am. This is a big step for both of us, but I couldn't be more thrilled." Sayori: (placing a hand on MC's arm) "Thank you, everyone. Your support means so much to us." Natsuki: (grinning) "Alright, now that we're all caught up, let's get back to sharing poems. MC, you can go next." MC: (nodding) "Sure thing, Natsuki. I have a special poem I've been working on just for this occasion." (As MC starts reading their poem, the rest of the club listens intently, their excitement for Sayori's pregnancy mingling with the anticipation of what the future holds for all of them.)