Loading
Home › Computer Science Help › MIS - Database Management Systems - Write the SQL code to...
Status: Completed
 View Work

MIS - Database Management Systems - Write the SQL code to create the table structures for the entities shown

Date Posted: 31/07/2018
Category: Computer Science
Due Date: 05/08/2018
Instruction
2. Use the attached "Ch08_Movieco_Create_Table.txt" and "Ch08_Movieco_Insert_data.txt" as a base to create tables and data for problems 47-48 in pp.433 of the textbook. (30%) You may need to fix minor errors so that the results will be the same as the 6 tables and the associate data displayed in pp. 433-436 of the text book. Trace the log or take a screen shot to show your work when you run sql file to create the tables and insert the data. Copy and paste the screen shot/log into the Word document file. 3. a).Use "SELECT * FROM USER_TABLES" and "DESCRIBE tablename" in sqlplus to verify the tables are created correctly. (screen shot) b).Use "SELECT COUNT(*) FROM tablename" to verify the number of record are correct in each table. (screen shot) c). Trace the log or take a screen shot to show your work. Copy and paste the screen shot/log into the Word document file (30%) Complete assignment on time
Attached
Download File 1 (jpg)
Download File 2 (jpg)
Download File 3 (jpg)
Download File 4 (txt)
Download File 5 (txt)
Download File 6 (txt)
Tutor Uploads
Download File 1 (docx)
Download File 2 (docx)
Bidders
ExcellentTutor 8 years, 2 months ago
Rated 9.09 earned 174531.76 around 5422 assignments.
Hello, Consider hiring me to do your assignment. I work fast, pay close attention to the instructions, and deliver a plagiarism-free paper. My price is also negotiable to accommodate your budget. Talk to me. Thank you.
$80.00
  • hello this is a quick and easy assignment if you know how to write sql code. im offering $20.. please consider, thanks
    User_4193 | Jul 31, 2018, 19:38 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[0] $}

{$ showNewChatSuccessMsg[0] $}
Unable to send Message: {$ showChatProcessErrorMsg[0] $}
 
 
Essaymasters 8 years, 2 months ago
Rated 8.94 earned 80799.14 around 2500 assignments.
I will do this assignment for you and I will give a fantastic job
$85.00
  • I will be sure to include all tables and forms for an A grade score
    Essaymasters | Jul 31, 2018, 19:30 PM
  • hello this is a quick and easy assignment if you know how to write sql code. im offering $20.. please consider, thanks
    User_4193 | Jul 31, 2018, 19:34 PM
  • Yes I see that it is an easy task but the extent of the work is much. I can however, make it 50 that the less I can go
    Essaymasters | Jul 31, 2018, 19:36 PM
  • i can offer you 25
    User_4193 | Jul 31, 2018, 19:39 PM
  • I really want to help you pass this project but my last price is 50
    Essaymasters | Jul 31, 2018, 19:41 PM
  • thank but 25 is my highest, please consider, assignment should take only a few minutes
    User_4193 | Jul 31, 2018, 20:00 PM
  • I am sure that I am the only tutor offering you the best price
    Essaymasters | Jul 31, 2018, 20:01 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[1] $}

{$ showNewChatSuccessMsg[1] $}
Unable to send Message: {$ showChatProcessErrorMsg[1] $}
 
 
phoniextutor 8 years, 2 months ago
Rated 8.98 earned 50856.21 around 1767 assignments.
Hello. Kindly hire me please, promise to deliver HIGH-QUALITY WORK, PLAGIARISM FREE and 100% GRAMMAR that will guarantee you A+
$120.00
  • hello this is a quick and easy assignment if you know how to write sql code. im offering $20.. please consider, thanks
    User_4193 | Jul 31, 2018, 19:34 PM
  • $20 no my friend
    phoniextutor | Jul 31, 2018, 19:35 PM
  • 25 would be my max offer, thank you
    User_4193 | Jul 31, 2018, 21:12 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[2] $}

{$ showNewChatSuccessMsg[2] $}
Unable to send Message: {$ showChatProcessErrorMsg[2] $}
 
 
richwhite 8 years, 2 months ago
Rated 9.35 earned 20716.09 around 553 assignments.
Hello. Kindly consider my bid and rest assured I will deliver the best work; desired high quality. I have reviewed the instructions, and the paper falls under my specialization, and I will do thorough research to ensure it fits all the academic standards. Moreover, I have studied the unit in my course degree and done related papers in previous semesters thus you can expect the most real work from me. My work is always plagiarism free, delivered before the deadline and good graded_96% and above. Once assigned, I always maintain regular communication until you get the desired final result you ordered for. Please review my profile previous clients’ testimonial reviews for proof of my capabilities. Kind regards.
$200.00
  • hello this is a quick and easy assignment if you know how to write sql code. im offering $20.. please consider, thanks
    User_4193 | Jul 31, 2018, 19:39 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[3] $}

{$ showNewChatSuccessMsg[3] $}
Unable to send Message: {$ showChatProcessErrorMsg[3] $}
 
 
ElemenM 8 years, 2 months ago
Rated 9.55 earned 44584.28 around 1434 assignments.
Hello, I guarantee you quality and timely work if you assign me the job.. Assurance in scoring grade A
$25.00
  • hello this is a quick and easy assignment if you know how to write sql code. im offering $20.. please consider, thanks
    User_4193 | Jul 31, 2018, 19:39 PM
  • Hello, I promise to deliver top class work.. Kindly accept my revised bid of $60
    ElemenM | Jul 31, 2018, 19:42 PM
  • this is a very simple assignment, if you have knowledge on the subject, 25 is my max
    User_4193 | Jul 31, 2018, 19:50 PM
  • Well okay, please assign me the job
    ElemenM | Jul 31, 2018, 19:56 PM
  • ok change your bid to 25 and ill accept, thank you
    User_4193 | Jul 31, 2018, 21:11 PM
  • ive assigned it to you, please keep me posted, and let me know if you have any questions.. thank you
    User_4193 | Jul 31, 2018, 21:48 PM
  • Hey hope everything is going well, please keep me updated on your progress, also don't forget to take screen shots when necessary.
    User_4193 | Aug 01, 2018, 23:36 PM
  • Alright. I'll keep you posted
    ElemenM | Aug 02, 2018, 02:04 AM
  • Hi, please see attached completed assignment. Kindly release the payment
    ElemenM | Aug 02, 2018, 11:54 AM
  • Thank you, i have 4 questions if you could answer pertaining to the assignment... 50. Write the SQL command to change the price code for all action movies to price code 3. 52. Alter the DETAILRENTAL table to include a derived attribute named DETAIL_DAYSLATE to store integers of up to three digits. The attribute should accept null values.
    User_4193 | Aug 02, 2018, 15:34 PM
  • 58. Create a trigger named trg_late_return that will write the correct value to DETAIL_DAYSLATE in the DETAILRENTAL table whenever a video is returned. The trigger should execute as a BEFORE trigger when the DETAIL_RETURNDATE or DETAIL_DUEDATE attributes are updated. The trigger should satisfy the following conditions: If the return date is null, then the days late should also be null. If the return date is not null, then the days late should determine if the video is returned late. If the return date is noon of the day after the due date or earlier, then the video is not considered late, and the days late should have a value of zero (0). If the return date is past noon of the day after the due date, then the video is considered late, so the number of days late must be calculated and stored.
    User_4193 | Aug 02, 2018, 15:34 PM
  • 61. Create a stored procedure named prc_new_rental to insert new rows in the RENTAL table. The procedure should satisfy the following conditions: The membership number will be provided as a parameter. Use a Count() function to verify that the membership number exists in the MEMBERSHIP table. If it does not exist, then a message should be displayed that the membership does not exist and no data should be written to the database. If the membership does exist, then retrieve the membership balance and display a message that the balance amount is the previous balance. (E.g., if the membership has a balance of $5.00, then display “Previous balance: $5.00”.) Insert a new row in the rental table using the rent_num_seq sequence created above to generate the value for RENT_NUM, the current system date for the RENT_DATE value, and the membership number provided as the value for MEM_NUM.
    User_4193 | Aug 02, 2018, 15:35 PM
  • Hi, let me look at the questions..I think you should please also consider adding me alittle amount for this..
    ElemenM | Aug 02, 2018, 15:49 PM
  • yes I'll add bonus when you complete these questions... thank you
    User_4193 | Aug 02, 2018, 16:05 PM
  • Hi, I have uploaded the four questions as requested. Kindly release the payment and bonus as agreed
    ElemenM | Aug 03, 2018, 09:45 AM
  • Hi, kindly release the payment and bonus as agreed
    ElemenM | Aug 03, 2018, 19:27 PM
  • Hi, please release the payment..
    ElemenM | Aug 04, 2018, 02:13 AM
  • Hey sorry for the delay.. I will review to make sure its completion and release the funds and a bonus tomorrow.. thanks for all your help and patience
    User_4193 | Aug 04, 2018, 03:09 AM
  • Hi, well noted
    ElemenM | Aug 04, 2018, 03:11 AM
  • Hello, kindly note that I still have not received the payment
    ElemenM | Aug 05, 2018, 02:07 AM
  • Hello, the funds and bonus have been released, thank you for your help and i hope to work again with you in the future.
    User_4193 | Aug 05, 2018, 18:02 PM
  • Hi, thank you so much.. It would be my pleasure to work with you again
    ElemenM | Aug 05, 2018, 18:05 PM
  • Hi, kindly don't forget to rate my work as per your full fillment
    ElemenM | Aug 05, 2018, 18:11 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[4] $}

{$ showNewChatSuccessMsg[4] $}
Unable to send Message: {$ showChatProcessErrorMsg[4] $}
 
 
seniorwritersteve 8 years, 2 months ago
Rated 8.6 earned 16849.88 around 514 assignments.
Hello Friend! I would like the opportunity to complete your task. I have read the instructions, and I can guarantee the delivery of correct answers within your deadline. I will pay close attention to the instructions to ensure I do not miss a thing. I will pass the work in the software I have to ensure it free of plagiarism and grammatical errors. Kindly assign me.
$95.00
  • hello this is a quick and easy assignment if you know how to write sql code. im offering $20.. please consider, thanks
    User_4193 | Jul 31, 2018, 21:12 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[5] $}

{$ showNewChatSuccessMsg[5] $}
Unable to send Message: {$ showChatProcessErrorMsg[5] $}