Find Jobs
Hire Freelancers

Databases Assignment

$10-30 CAD

Berlangsung
Dibuat hampir 8 tahun yang lalu

$10-30 CAD

Dibayar ketika dikirim
workshop instructions Write the SQL command to create the customer and the invoice tables using the InnoDB database engine. Define the PK for each table and a FK constraint on CUS_CODE of the invoice table. Run the following query: select * from INFORMATION_SCHEMA.KEY_COLUMN_USAGE and show the output. Write the SQL command to insert a record in the invoice table with a CUS_CODE that does not exist in the customer table. Show the output message returned by mysql. Drop the FK constraint on CUS_CODE of the invoice table and redefine it with “on HYPERLINK "[login to view URL]"update HYPERLINK "[login to view URL]" HYPERLINK "[login to view URL]"cascade” and “on HYPERLINK "[login to view URL]"delete HYPERLINK "[login to view URL]" HYPERLINK "[login to view URL]"cascade” clauses. Write sql commands to insert one record in the customer table and one record in the invoice table. Check how Foreign keys help guarantee referential integrity within the database. Check the data in both tables and show the output. Write a sql command to change the CUS_CODE in the customer table to any new value. Show what message do you get from the system. Check the data in both tables and show the output. Write a sql command to delete all rows from the customer table. Show what message do you get from the system. Check the data in both tables and show the output. Drop the FK constraint on CUS_CODE of the invoice table and redefine it with “on HYPERLINK "[login to view URL]"update HYPERLINK "[login to view URL]" HYPERLINK "[login to view URL]"restrict” and “on HYPERLINK "[login to view URL]"delete HYPERLINK "[login to view URL]" HYPERLINK "[login to view URL]"restrict” clauses. Check how Foreign keys help guarantee referential integrity within the database. Write a sql command to update the CUS_CODE of any record in the customer table. What message do you get? Write a sql command to delete the records of the customer table. What message do you get? Load the sample data of your assignment for the customer and the invoice tables. Write the SQL query to get the product of the two tables. To get the product of two tables T1 and T2, run the following query: select * from T1, T2. Show the output. Write the SQL query to get the list of all customers and their corresponding invoices when available. Use left Join. As you do not have the super privilege on your mysql account under zenit to create triggers, Use [login to view URL] or your own installation of mysql. Using [login to view URL], provide a username and password and database name as well. You will need to activate your account by clicking on a link sent to your email while the creation of the account. Once you login, create the customer and the invoice table and create the following triggers. Create a trigger before insert on the customer table that checks if the balance is different than zero and if so it sets its value to zero. Write the sql command to insert a customer record with a balance different than zero, then check the data in the table. Create a trigger before insert on the invoice table that sets the value of the invoice total as the sum of invoice subtotal and invoice tax. Write the sql command to insert an invoice record without providing a value for the invoice total, then check the data in the table. more info in attached document.
ID Proyek: 10008421

Tentang proyek

5 proposal
Proyek remot
Aktif 8 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
5 freelancers are bidding on average $72 CAD for this job
Avatar Pengguna
A proposal has not yet been provided
$111 CAD dalam 1 hari
4,8 (16 ulasan)
4,4
4,4
Avatar Pengguna
Hello, I have read your project description about Database Design and I would appreciate if you can open discussion with me and I see how we can work together. Am a graduate in Computer Science and have already designed a School Management System using MySQL and Java. In this project I applied database skills which your project needs. If you award me the project I will work closely with you throughout the whole project life span, communicating continuously at every stage with updates requesting any revisions or additions that need to be made. I will also work with you until the project comes to fruition, in perfect condition, and ready for submission. I realize that each academic project is unique and requires thoughtful research. With care and planning we can work together to create something which can fulfill your expectations. Hope to work with you soon! Looking forward to hear from you Thanks Nyaronyari
$30 CAD dalam 1 hari
5,0 (3 ulasan)
2,1
2,1
Avatar Pengguna
I am expert in databases and can do the task as per your requirements. .
$25 CAD dalam 1 hari
3,0 (3 ulasan)
1,9
1,9
Avatar Pengguna
A proposal has not yet been provided
$35 CAD dalam 1 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera CANADA
Hamilton, Canada
5,0
27
Memverifikasi Metode pembayaran
Anggota sejak Feb 22, 2016

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.