SQL alternative for the Project 3 SQL alternative for Lab 6 (full credit is 8 correct answers) Please prepare the description what the Access figure represents and create appropriate SQL code and...

Microsoft Access SQL problems


SQL alternative for the Project 3 SQL alternative for Lab 6 (full credit is 8 correct answers) Please prepare the description what the Access figure represents and create appropriate SQL code and description for each figure in each slide. Your answers should look like: Q1-Q6: building tables and creating data entries Q7-Q10: for each query explain in text what the query does and write appropriate SQL code Q1, Q2 Q3, Q4 Q5, Q6 Q7 Q8 Q9 Q10 SQL alternative for the Project 3 SQL alternative for the Lab 7 (full credit is 8 correct answers) Please prepare a Word file with the description what each of the Access figures represents and create appropriate SQL code and description for each figure in each slide. Q1. Describe the figure below (Hint: your answer should look like: Relationship between tables, show primary key for each table cardinalities and Normalization for all tables Q2 and Q3. Write SQL codes to create both tables Q4: Create a SQL code for data entry for Members and put your name as a member and add one more member Q5-Q10: All queries are given in QBE code, describe what they do and write SQL code for each one of them Q5 Q6 Q7 Q8: Solve the Q7 without using the instruction BETWEEN Q9 Q10