I have created database for a rental company. I will provide the sql statement for create that database. i have an assignment to write sql statement to edit, creat view of the database. some of the questions are
3) Create a distributed database using VIEWS. The Primary Horizontal Fragmentation will be on the Client table. Fragment the client table based on state. You will have three fragments, NY, NJ, and PA. Next create Derived Horizontal Fragmentation using the Client and Rentals tables. Last create Derived Horizontal Fragmentation using the Rentals and Vehicles tables.
4) Grant me SELECT access to all your tables and views. User ID: prof_warmond.
5) Insert yourself as a client and assign two rentals to you.