User Account

All Pages

Define the entities, attributes and draw ERD

Assignment Help PL-SQL Programming
Reference no: EM132911170

Application Requirement:

Teachers, Tutors and Students: A user visiting to the platform must register their roles. If the user wants to learn language courses, then she or he has to register as the student role. If the user wants to teach a course at the platform, she or he must send a request for registering the role of Teacher or Tutor based on the approval of the website manager.

Students need to have necessary information, including student name (first and last name), home address (street, city, postcode), Nationality, age, email, mobile phone number, date of birth, gender, language needs (e.g., English, France), and the level of each language need (e.g., begin, intermediate, advanced).

In addition to personal information like students, each teacher or tutor must also have teaching experience information, e.g., degree, language teaching preferences, teaching level of each language (begin, intermediate, advanced), and last 5 years' teaching experience if applicable (such as 2 years' teaching at Lingolink platform, 1 year's teaching at Youtube platform, 0.5 year's teaching at language centre).

Course: There are two types of courses, one-to-one teaching course, and group teaching course. For the one-to-one teaching course, a student needs to pay $50 per hour. For the group teaching course, each student in the group needs to pay $20 per hour. The group teaching course is only open if there are more than 3 students.

Before a student commences her or his course, she or he needs to book the course from one teacher or tutor. At the end of each course, the student has to pay the course fee to platform account, with the payment. Students have option to leave a short comment about the attended course.

By the end of each month, the platform will charge 20% course fee, and pay the remaining 80% course fee to the teachers based on their taught courses within the month.

Platform Management Teams: Lingolink has different teams to support the services of the platform.

- Platform language experts will handle the request of users who would like to register the roles of teacher or tutor. The platform language experts will change the status of a user from "Waiting" to "Approved" if a user's request was approved, otherwise, the status was changed to "Denied".
- Platform Finance Officers will process the monthly payment to each teacher or tutor, process the salaries to platform staffs, and also report the monthly revenue of the platform to the CEO.
- Platform Technical Staff will provide the support to the platform, and their salaries are classified into three levels - Junior Level, Senior Level, Manager Level. Each team has only one manager to lead the team.

All students, teachers and tutors can login into the system and system will keep record of login history.

Question 2.1: Define the entities, attributes and draw ERD.

Question 2.2: Normalize each relation to 3NF.

Attachment:- Application Requirement.rar

Reference no: EM132911170

Questions Cloud

Discuss the general framework for classification : Discuss the general framework for classification. What is a decision tree and decision tree modifier? Note the importance.
Explain coastal translation exposure : Question - Explain Coastal's translation exposure. How could Coastal hedge its translation exposure
Calculate the cost of the equity for preference shares : Preference shares pay a constant dividend of $5 per year. Calculate the cost of the equity for preference shares and the value of preference shares.
Best definition for mineral nutrients : Which of the following vitamins can be synthesized by the human body? What is the best definition for mineral nutrients?
Define the entities, attributes and draw ERD : Define the entities, attributes and draw ERD - Normalize each relation to 3NF - Lingolink has different teams to support the services of the platform
Prepare the relevant general journal entries from july up to : Prepare the relevant general journal entries from 1 July 2020 up to and including 30 June 2021 in the books of Wayne Ltd under the equity method
Explain the economic impact of observing business : 1. Explain the economic impact of observing business 2. What is the impact of business ethics to society in general?
What do you need to consider during a virtual interview : What do you need to consider during a virtual interview?
Explain strategic control process : a. Discuss, in brief, the strategic control process.

Reviews

Write a Review

PL-SQL Programming Questions & Answers

  Create a database model

Create a database model and Submit the table creation statements for the Database Model.

  Write pl-sql procedures and functions

Write PL/SQL procedures and functions to populate and query that database

  Sql questions

Write a query to display using the employees table the EMPLOYEE_ID, FIRST_NAME, LAST_NAME and HIRE_DATE of every employee who was hired after to 1 January, 1995.

  Run the lab_03_01.sql script

Run the lab_03_01.sql script in the attached file to create the SAL_HISTORY table. Display the structure of the SAL_HISTORY table.

  Write sql queries

Write a query to display the last name, department number, and salary of any employee whose department number and salary both match the department number and salary of any employee who earns a commission.

  Explaining sql insert statement to insert new row in cds

Write down a SQL insert statement to insert new row in "CDS" table.

  Write down name of actors in ascending order

Write down actors (or actress, your choice, but not both) who have won at least two (2) Academy Awards for best actor/actress. Provide the actor name, movie title & year. Order the result by actor name."

  What is an sql injection attack

What is an SQL injection attack? Explain how it works, and what precautions must be taken to prevent SQL injection attacks.What are two advantages of encrypting data stored in the database?

  Determine resonant frequency in series rlc resonant circuit

Given the series RLC resonant circuit in the figure, operating at variable frequency, determine: The resonant frequency ω o ,  The circuit’s quality factor Q , The cut-off frequencies, f 1  & f 2  and the bandwidth BW

  Query that uses cube operator to return lineitemsum

Write summary query which uses CUBE operator to return LineItemSum (which is the sum of InvoiceLineItemAmount) group by Account(an alias for AccountDesciption).

  Query to show customers were missing for existing orders

As DBA, your manager called a meeting and asked why there are so many orders for customers that don't exist in the customer table. Write query which would shows which customers were missing for existing orders. Use a join or a subquery.

  Sql query into a relational algebra statement

Turn this SQL query into a relational algebra statement? SELECT Request.reqfor, Ordering.invamt, Ordering.invnbr, Ordering.invdat

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd