Assumption : Every contributor is assigned one FOSS series for translation and d

Question

Assumption : Every contributor is assigned one FOSS series for translation and dubbing process. Each FOSS has 10 tutorials. Admin has already decided deadlines for submission, which are stored in tutorial_detail table.

You have to-

Create a mysql database with 4 tables : user, foss, tutorial_detail, payment.

Display a list of tutorials contributed with expected submission date and actual submission date for one calendar month.

Write a program to count the number of published tutorials that each contributor has submitted in one calendar month.

Multiply the total number of tutorials by Rs.1000.

Calculate the final payment amount for each contributor and display it in a list.

Explanation / Answer

Solution:

The first question is done as per Chegg guidelines, please repost others.

Create a mysql database with 4 tables : user, foss, tutorial_detail, payment.

Table=> user

CREATE TABLE user(
    userID int NOT NULL,
userName;
    PRIMARY KEY (userID)
);

Table=> Foss

CREATE TABLE foss(
    fossID int NOT NULL,
fossName;

    PRIMARY KEY (fossID)
);

Table=> tutorial_details

CREATE TABLE tutorial_detail(
    tutorialID int NOT NULL,
tutorialName,

date,

month'
    PRIMARY KEY (tutorialID)
);

Table=> payment

CREATE TABLE payment(
    paymentID int NOT NULL,
paymentAmount;
    PRIMARY KEY (paymentID)
);

Display a list of tutorials contributed with expected submission date and actual submission date for one calendar month.

SELECT tutorialID FROM tutorial_details WHERE month= 'January' //extracting data for one calender month

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.