Using the MUSIC AGENCY
Enterprise on the following pages, you are to:
1. Load the musicAlgebra.rdb file in WinRDBI.
2. Develop relational algebra solutions for the queries specified in this assignment. Comment the queries and use descriptive table and attribute names. An overview of the use of WinRDBI was covered in class. See the resources below for additional information on WinRDBI:
1. The WinRDBI Web (http://winrdbi.asu.edu) provides online demos and sample queries.
2. Understanding Relational Database Query Languages, S. W. Dietrich, Prentice Hall, 2001. On the due date, you will turn in the following:
1. A pdf of your query file (.alg), and the results of ONLY the 5 queries from WinRDBI. Make sure that the listing includes your name and class as a comment line in your .alg file.
2. An electronic copy of your query file must be turned on Canvas. To avoid name clashes on files, name your .alg file: LastnameFirstname.alg
Get Free Quote!
424 Experts Online