Question: Step 4 of Your PDA ( Personal Database Application ) In this PDA you shall write and run some SQL queries. If you wish, you
Step of Your PDA Personal Database Application In this PDA you shall write and run some SQL queries. If you wish, you may follow the routine of loading your database from your load file, running queries or other commands from a file that contains those SQL statements and then deleting your data so it doesn't clutter up the database all week and worse you don't forget and load the same tuples several times into your relations. Remember that SQL thinks of relations as bags, and so will happily let you insert the same tuple as many times as you ask it to To clean out a relation R without deleting the schema itself, use command DELETE FROM R; pts Write three queries on your PDA database, using the selectfromwhere construct of SQL To receive full credit, all but perhaps one of your queries should exhibit some interesting feature of SQL: queries over more than one relation, or sub queries, for example. We suggest that you experiment with your SQL commands on a small database eg your handcreated database before running them on the large database that you loaded in PDA step Initial debugging is much easier when you're operating on small amounts of data. Once you're confident that your queries are working, run them on your complete database. If you discover that most or all of your interesting queries return an empty answer on your large database, check whether you followed the instructions in step for generating data values that join properly. You will need to modify your data generator accordingly. Turn in a copy of all your SQL queries, along with a script illustrating their execution. pts Write three data modification commands on your PDA database. Most of these commands should be interesting in the sense that they involve some complex feature, such as inserting the result of a query, updating several tuples at once, or deleting a set of tuples that is more than one but less than all the tuples in a relation. As for the queries in a you might want to try out your commands on small data before trying it on your full database. Hand in a script that shows your modification commands running in a convincing fashion. pts Create a report for part a using report facility of your DBMS softwareOracle Access, MySQL etc.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
