An E-learning website needs your help to design its database. They need to store information about teachers and online tutorials. Each teacher has a unique ID, name, and at least one field of specialty. Teachers form groups to prepare online tutorials. Each group has unique name and at least one teacher as a member. Each online tutorial has a title, date and organized by exactly one group. The title of the tutorial is unique for the group. Each tutorial consists of several sessions, described by their titles and durations. Naturally, each session is presented by one teacher and belongs to exactly one tutorial. In addition, sessions on the same tutorial have different titles. Design an ERD for this application. Note any unspecified requirements, and make appropriate assumptions to make the specification complete.

An E-learning website needs your help to design its database. They need to store information about teachers and online tutorials. Each teacher has a unique ID, name, and at least one field of specialty. Teachers form groups to prepare online tutorials. Each group has unique name and at least one teacher as a member. Each online tutorial has a title, date and organized by exactly one group. The title of the tutorial is unique for the group. Each tutorial consists of several sessions, described by their titles and durations. Naturally, each session is presented by one teacher and belongs to exactly one tutorial. In addition, sessions on the same tutorial have different titles. Design an ERD for this application. Note any unspecified requirements, and make appropriate assumptions to make the specification complete.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter1: Overview Of Database Concepts

Section: Chapter Questions

Problem 5HOA: Access path A database table is composed of records and fields hold data. Data is stored in records....

See similar textbooks

Similar questions

A book is identified by its ISBN number, and it has a title, a price, and a date of publication. It is published by a publisher, which has its own ID number and a name. Each book has exactly one publisher, but one publisher typically publishes multiple books over time.
Database Systems: System Description: Branches Dream Home has branch offices in cities throughout the United Kingdom. Each branch office is allocated members of staff, including a Manager, who manages the operations of the office. The data describing a branch office includes a unique branch number, address (street, city, and postcode), telephone numbers (up to a maximum of three), and the name of the member of staff who currently manages the office. Additional data is held on each Manager, which includes the date that the Manager assumed his or her position at the current branch office, and a monthly bonus payment based upon his or her performance in the property for rent market. Staff Members of staff with the role of Supervisor are responsible for the day-to-day activities of an allocated group of staff called Assistants (up to a maximum of 10, at any one time). Not all members of staff are assigned to a Supervisor. The data stored regarding each member of staff includes staff…
Database Management Jill Bill Marketplace is a business located in Florida. Within the JBM compound, you can purchase many types of products that are related to a specific category, for example, books or antiques. JBN does not own any of the stalls that sell products, rather they rent them out to small vendors. Each vendor has to pay a monthly fee to use the Marketplace. JBM products are available to different customers who sell their products daily. Each category type (e.g. books ) is managed by a particular supervisor. A customer will order their selected product in terms of the amount from that vendor, who is also free to apply discounts on any product in his store. Other than category supervisors there are other staff that manages different departments in the mall, but they all report to two marketplace managers. The small vendors will report to the category managers on the nature of their stock and if and when restocking is required. All category managers report to the third…
System Description: Branches Dream Home has branch offices in cities throughout the United Kingdom. Each branch office is allocated members of staff, including a Manager, who manages the operations of the office. The data describing a branch office includes a unique branch number, address (street, city, and postcode), telephone numbers (up to a maximum of three), and the name of the member of staff who currently manages the office. Additional data is held on each Manager, which includes the date that the Manager assumed his or her position at the current branch office, and a monthly bonus payment based upon his or her performance in the property for rent market. Staff Members of staff with the role of Supervisor are responsible for the day-to-day activities of an allocated group of staff called Assistants (up to a maximum of 10, at any one time). Not all members of staff are assigned to a Supervisor. The data stored regarding each member of staff includes staff number, name, address,…
System Description: Branches Dream Home has branch offices in cities throughout the United Kingdom. Each branch office is allocated members of staff, including a Manager, who manages the operations of the office. The data describing a branch office includes a unique branch number, address (street, city, and postcode), telephone numbers (up to a maximum of three), and the name of the member of staff who currently manages the office. Additional data is held on each Manager, which includes the date that the Manager assumed his or her position at the current branch office, and a monthly bonus payment based upon his or her performance in the property for rent market. Staff Members of staff with the role of Supervisor are responsible for the day-to-day activities of an allocated group of staff called Assistants (up to a maximum of 10, at any one time). Not all members of staff are assigned to a Supervisor. The data stored regarding each member of staff includes staff number, name, address,…
System Description: Branches Dream Home has branch offices in cities throughout the United Kingdom. Each branch office is allocated members of staff, including a Manager, who manages the operations of the office. The data describing a branch office includes a unique branch number, address (street, city, and postcode), telephone numbers (up to a maximum of three), and the name of the member of staff who currently manages the office. Additional data is held on each Manager, which includes the date that the Manager assumed his or her position at the current branch office, and a monthly bonus payment based upon his or her performance in the property for rent market. Staff Members of staff with the role of Supervisor are responsible for the day-to-day activities of an allocated group of staff called Assistants (up to a maximum of 10, at any one time). Not all members of staff are assigned to a Supervisor. The data stored regarding each member of staff includes staff number, name, address,…
DATABASE SYSTEMS: QUESTION Do as directed This describes the business process to publish an academic paper. The author submits a paper to an editor in chief of a journal. The editor first checks whether the paper fit the theme of the journal. If not, the editor rejects the paper. Otherwise, the editor in chief assigns the paper to a number of reviewers. The reviewers review the paper, and write a review. The review is sent to the editor in chief. The editor in chief then assesses the quality of the paper with the help of reviewers’ comments. If the quality is good, the paper will be accepted, and the author notified. Furthermore, the paper is forwarded to the publisher for publication. If the quality is bad, the editor rejects the paper. Apply query to only access to compile the final decision to editor in chief and only visualized by author not reviewers
Skiing Database You are a member of New England Ski Club. The Manager of the Ski Club has asked you to design a database to keep track of member and skiing resort information. For each member of the club, the manager will need their name, address, phone number, skiing ability data. For the various ski resorts, you will need to track the name of the resort, # of trails, # of lifts. Also needed is a monthly report of skier activity including the skier's name, phone number, skiing ability, Ski resort visited, the date of the visit and general comments on the skiing there. Create the DBDL for the database using word. Do not over think this case. Do not make any assumptions. You must use the following table names: (Member, Resort, Activity and Ability.) Language: SQL
write access model Only Leena can access her laptop. The website can be accessed only during work time The file is a read-only file. Only course instructors can access students' data.
Business Rules: Each musician at NewTalent should have a name, address, and phone number on the system. The Instruments used in the songs have a unique name, musical genre (i.e. rock, pop, hip hop), and type (i.e. string, piano, guitar). Every album recorded under the NewTalent label has a title, copyright date, format, and an album identifier. Each song recorded has a title and an author. Musicians can play several instruments, and an instrument can be played by multiple musicians. Every album contains several songs, but a song can only appear on one album. Songs are performed by one or more musicians, and a musician can perform numerous songs. Each album has one musician acting as its producer, although a musician can produce multiple albums. Create an ERD for the above scenario that describes its business rules. Use Crow's Foot notations and make sure to include all of the following: All entities correctly identified with Primary key and any foreign key attributes.…
Property Estate AgentClients who want to sell their home go to an estate agent, who will take measurements of their home, flat, or bungalow and record them on a card that is organised by area, price range, and type of property. A similar type of card is completed by potential purchasers and filed in an A4 binder by buyer name. The estate agent matches the needs of potential buyers with available houses on a weekly basis and provides them the data of selected properties. When a sale is completed, the buyer acknowledges that the contracts have been exchanged, the client's information is removed from the property file, and the customer receives an invoice. The top copy of a three-part set is given to the client, with the other two copies being filed.The invoice copies are stamped and archived once payment is received. Monthly invoices are reviewed, and accounts that have not been paid within two months receive a reminder (the third copy of the invoice).Question 1 With reference to…
Requirements About the System: A local library intends to modernize its operations and seeks your assistance in designing its system. The following are the requirements for the library system: The library possesses a collection of books that can be borrowed by its members. Each book has a unique ISBN, title, author, and publication year. Members can search for books, check their availability, and place a hold on a book if it is unavailable. When a book is available, the member can borrow it and the due date will be calculated based on the library's lending policy. Members can return books, and the system should keep track of the books they have borrowed and the ones they have returned. Q1: Use Case Diagram: Identify the use cases for the library system and draw a use case diagram to depict the relationships between the actors and use cases. (I need help with a use case diagram using the requirements above. We are doing these in drawio) Here is an example of what one is supposed to…