This focuses on how MySQL Workbench is used toĬreate a model and then a DB from it, rather than on ER Use MySQL Workbench to create a simple ER model and use theįorward Engineering functionality of Workbench to create a simpleĭB (specs follow). Use MySQL Workbench to create a simple ER model and use the.The trigger should satisfy the following conditions: a Calculate the value of the late fee prior to the update that triggered this execution of the trigger. The trigger should execute as an AFTER trigger when the due date or return date attributes are updated in the DETAILRENTAL table. 3 Create a trigger named trg_mem_balance that will maintain the correct value in the membership balance.ģ Create a trigger named trg_mem_balance that will maintain the correct value in the membership balance in the MEMBERSHIP table when videos are returned late.What did you write for your stored procedure? Insert the snip Display the total number of days missed forĪ. Create a stored procedure that for any student id entered, a Using the Class database, answer the following questions:ġ. Using the Class database, answer the following questions:ġ.If the import fails, fix it in the model. In Workbench, then forward-engineer the database script and import This problem mimics the one from the previous assignment. Turn in 1 Workbench file, 1ĭocument with the forward-engineered sql statements, and a Word MySQL Workbench has more capability than Lucidchart, as it allowsĬreation of DDL SQL from the model. MySQL Workbench has more capability than. Use MySQL Workbench for these questions.May not require 10 records and that is ok as long as your mainĬreate MySQL statements that will retrieve all records or rowsĬreate 10 MySQL statements that will retrieve specified records Using the MySQL Workbench create a new database using yourĪdd at least 10 records to your tables. Using the MySQL Workbench create a new database using your.VALUES (RENT_NUM_SEQ.NEXTVAL, SYSDATE, MEM_NUM_TEMP) INSERT INTO RENTAL (RENT_NUM, RENT_DATE, MEM_NUM) ![]() ![]() SELECT MEM_BALANCE INTO PREV_MEM_BALANCE FROM MEMBERSHIPĭbms_output.put_line('Previous Balance is: '|| Previous balance and insert values in the table */ * - if membership number count is not zero, then display SELECT COUNT(*) INTO COUNT_MEMBER FROM MEMBERSHIPĭbms_output.put_line('A membership with number ' || MEM_NUM_TEMP PREV_MEM_BALANCE MEMBERSHIP.MEM_BALANCE%TYPE MEMBERSHIP.MEM_NUM%TYPE) AS COUNT_MEMBER NUMBER a membership number is provided, which is passedĬREATE OR REPLACE PROCEDURE prc_new_rental (MEM_NUM_TEMP IN the stored procedure to be created is called In a table, given it satisfies the provided conditions in the You can create a stored procedure to insert new rows
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |