M Online finax M Inbox (827 X M Inbox (1,40 x LMS: Canv. x Virtual Cla: x Meet - x W COVID Live x Cb Cricket sco X M Chegg-six + 0 f c .mail.google.com/mail/u/0/?tab=rm&ogbl#inbox/FMfcgzGmtFFxfzxzdkGqZbZWcvwSXNNx?projector=1&messagePartld=0.1 M Gmail S 1 of 2,775 > Compose 1.a) What is the difference between inner join and natural join? Explain with an example. b) Suppose you have the following tables. Write down the output of the following join operations. 8 12 credits prereq id Mail course_id title dept_name CSE-301 DataCom CSE EEE-200 Circuit Design EEE CSE-321 Database CSE Course 3 3 course id CSE-301 CSE-235 EEE-200 EEE-100 CSE-333 CSE-305 Prerequisite Inbox 1,089 minutes ago) Starred i) Left Outer Join ii) Right Outer Join iii) Full Outer Join c) How you can Grant and Revoke authorization of a database user? 5 Snoozed 15 Sent 2.a) What is a Database Transaction? "A transaction in a database can be in one of the following five states". Describe each state. Chat Partially Committed Committed Begin Active End No conversations Start a chat Failed Aborted Spaces b) Describe the ACID properties of a database transaction. 10 7 18 No spaces yet Create or find a space 3.a) What is the difference between weak entity sets and strong entity sets? b) Analyze the following cases and show the mapping cardinalities for the relationship sets between the following entities by suitable E-R diagram: (Mention some possible attributes of each entity) i. Actor to Movie ii. Owner to Car iii. Student to Course iv. Country to Prime minister v. Price to Product vi. Employee to Department Activate Windows Go to Settings to activate Windows. Meet i o Q 2 67F Haze 12:22 PM 1/1/2022 FIN