3) Draw a domain class diagram according to the below scenario: Suppose that you are designing a schema to record information about reality shows on TV. Your database needs to record the following information: • For each reality show, its name, genre, basic_info and participants name. Any reality show has at least two or more participants. • For each producer, the company name, company country. A show is produced by exactly one producer. And one producer produces exactly one show. • For each television, its name, start year, head office. A television may broadcasts multiple shows. Each show is broadcasted by exactly one television. For each user, his/her username, password, and age. A user may rate multiple shows, and a show may be rated by multiple users. Each rating has a score of 0 to 10.

3) Draw a domain class diagram according to the below scenario: Suppose that you are designing a schema to record information about reality shows on TV. Your database needs to record the following information: • For each reality show, its name, genre, basic_info and participants name. Any reality show has at least two or more participants. • For each producer, the company name, company country. A show is produced by exactly one producer. And one producer produces exactly one show. • For each television, its name, start year, head office. A television may broadcasts multiple shows. Each show is broadcasted by exactly one television. For each user, his/her username, password, and age. A user may rate multiple shows, and a show may be rated by multiple users. Each rating has a score of 0 to 10.

Fundamentals of Information Systems

9th Edition

ISBN:9781337097536

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter3: Database Systems And Big Data

Section: Chapter Questions

Problem 4PSE

See similar textbooks

Similar questions

Create a conceptual schema for the following database domain. To make it completely clear, only one (the final) conceptual schema is expected. A book is described by ISBN and a title. ISBN uniquely identifies each book. A book consists of many chapters. A chapter is described by a chapter number, title and topic. Each chapter has a unique number within a book. A chapter belongs to one book only. A book is written by one or more authors. An author can write one or more books. An author is described by the first name, last name, date of birth, and country the author comes from. A triple of values: (first name, last name and date of birth) uniquely identifies each author. We have three types of books: textbooks, fiction books and biographies. A textbook is additionally described by the titles of course it has been applied to. A textbook can be applied to none or more courses. i need answer with diagram
Consider the following relations for a database that keeps track of student enrolment in courses and the books adopted for each course: STUDENT(SSN, Name, Major, Bdate) COURSE(Course#, Cname, Dept) ENROLL(SSN, Course#, Quarter, Grade) BOOK ADOPTION(Course#, Quarter, Book_ISBN) TEXT(Book_ISBN, Book Title, Publisher, Author) Draw a relational schema diagram specifying the foreign keys for this schema. Consider the following relations for a database that keeps track of student enrolment in courses and the booksadopted for each course: STUDENT(SSN, Name, Major, Bdate) COURSE(Course#, Cname, Dept) ENROLL(SSN, Course#, Quarter, Grade) BOOK ADOPTION(Course#, Quarter, Book_ISBN) TEXT(Book_ISBN, Book Title, Publisher, Author) Draw a relational schema diagramspecifying the foreign keys for this schema.
5.14 - Consider the following six relations for an order-processing database application in a company: CUSTOMER (Cust#, Cname, City) ORDER (Order#, Odate, Cust#, Ord_Amt) ORDER_ITEM (Order#, Item#, Qty) ITEM (Item#, Unit_price) SHIPMENT (Order#, Warehouse#, Ship_date) WAREHOUSE (Warehouse#, City) Here, Ord_Amt refers to total dollar amount of an order; Odate is the date the order was placed; Ship_date is the date an order (or part of an order) is shipped from the warehouse. Assume that an order can be shipped from several warehouses. Specify the foreign keys for this schema, stating any assumptions you make. What other constraints can you think of for this database?
Develop an EER model for the following situation using the traditional EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor: An international school of technology has hired you to create a database management system to assist in scheduling classes. After several interviews with the president, you have come up with the following list of entities, attributes, and initial business rules: • Room is identified by Building ID and Room No and also has a Capacity. A room can be either a lab or a classroom. If it is a classroom, it has an additional attribute called Board Type. • Media is identified by MType ID and has attributes of Media Type and Type Description. Note: Here we are tracking type of media (such as a VCR, projector, etc.), not the individual piece of equipment. Tracking of equipment is outside the scope of this project. • Computer is identified by CType ID and has attributes Computer Type, Type Description,…
Consider a MOVIE database in which data is recorded about the movie industry. The data requirements are summarized as follows: -- Each movie is identified by title and year of release. Each movie has a length in minutes and a rating (e.g., G, PG, or R). Each has a production company, and each is classified under one or more genres(such as horror, action, drama, and so forth). Each movie has one or more directors and one or more actors appear in it. Each movie also has a plot outline. Finally, each movie has zero or more quotable quotes, each of which is spoken by a particular actor appearing in the movie. An actor may have multiple quotes from one movie. -- Actors are identified by name and date of birth and appear in one or more movies. Each actor has a role in the movie, i.e., the character he or she plays. -- Directors are also identified by name and date of birth and direct one or more movies. -- Production companies are identified by name and each has an address. A production…
Develop an EER model for the following situation using EER notation, as specified by your instructor. An international school of technology has hired you to create a database management system to assist in scheduling classes. After several interviews with the president, you have come up with the following list of entities, attributes, and initial business rules: • Room is identified by Building ID and Room No and also has a Capacity. A room can be either a lab or a classroom. If it is a classroom, it has an additional attribute called Board Type. • Media is identified by MType ID and has attributes of Media Type and Type Description. Note: here we are tracking type of media (such as a DVD, projector, etc.), not the individual piece of equipment. Tracking of equipment is outside of the scope of this project. • Computer is identified by CType ID and has attributes of Computer Type and Type Description, Disk Capacity, and Processor Speed. Please note: as with Media Type, we are tracking…
Consider the following relations for a database that keeps track of student enrollment in courses and the books adopted for each course: STUDENT(SSN, Name, Major, Bdate) COURSE(Course#, Cname, Dept) ENROLL(SSN, Course#, Quarter, Grade) BOOK_ADOPTION(Course#, Quarter, Book_ISBN) TEXT(Book_ISBN, Book_Title, Publisher, Author) Draw a relational schema diagram specifying the foreign keys for this schema.
Draw an ER diagram and then map it into a relational schema(database) for the following scenario.• For each MEMBER we keep track of the unique MemdID, a well as Name, Zip, and the Datethe membership was paid.• For each MEMBERSHIP type we keep track of the unique Mid, as well as MName and Price• For each PASS CATEGORY we keep track of the unique PassCatID, as well as PCName andPrice• For each ONE DAY PASS we keep track of the unique PassID and Date• For each MERCHANDISE item we keep track of the unique MrchID, as well as Name andPrice• For each sale TRANSACTION we keep track of the unique Tid and Date• Each member pays for exactly one membership type; each membership type has at leastone member but can have many members.• Each member can buy many day passes but does not have to buy any, each day pass wasbought by exactly one member• Each day pass belongs to exactly one pass category; a pass category can have manyindividual day passes issued for it but does not have to have any. • Each…
Consider the following database scheme Employee (SSN, fname, lname, salary, deptno) Department (deptno, dname, total_salary) Where total salary is a derived attribute that represents the total salary of employees working in a specific department. Write a trigger to compute the total_salary in the event of inserting one or more new employee record(s) in the employee table.
Construct the ER diagram for the NHL database using the Crows Foot notation Suppose you are given the following requirements for a simple database for the National Hockey League (NHL):• the NHL has many teams,• each team has a name, a city, a coach, a captain, and a set of players,• each player belongs to only one team,• each player has a name, a position (such as left wing or goalie), a skill level, and a setof injury records,• a team captain is also a player,• a game is played between two teams (referred to as host_team and guest_team) andhas a date (such as May 11th, 2017) and a score (such as 4 to 2).
Consider the following information about a university database: ▪ Professors have an SSN, a name, an age, a rank, and a research specialty. ▪ Projects have a project number, a sponsor name (e.g., NSF), a starting date, an ending date, and a budget. ▪ Graduate students have an SSN, a name, an age, and a degree program (e.g., M.S. or Ph.D.). ▪ Each project is managed by one professor (known as the project’s principal investigator). ▪ Each project is worked on by one or more professors (known as the project’s co-investigators). ▪ Professors can manage and/or work on multiple projects. ▪ Each project is worked on by one or more graduate students (known as the project’s research assistants). ▪ When graduate students work on a project, a professor must supervise their work on the project. Graduate students can work on multiple projects, in which case they will have a (potentially different) supervisor for each one. ▪ Departments have a department number, a department…
Air West Airlines is a regional carrier that operates primarily in the southwestern United States. Draw an ER diagram to capture the following information in a database for the airline company. An airport is identified by a unique airport code and has a location which consists of (city, state), an elevation, and one or more phone numbers. An airport may have several flights to arrive at it and depart from it. A flight has a unique flight number, a base fare, and the number of seats. A flight can arrive at one or more airports and depart from one or more airports. For each arrival, the scheduled arrival time should be recorded. For each departure, the scheduled departure time should be recorded. Each flight has one or more staff members in its crew. Each staff member (who may be an attendant or a pilot, but not both) has a unique ID number, a name, and a hire date. A staff member may be assigned to several flights. Each flight attendant has a date for an advanced certification. Each…

SEE MORE QUESTIONS

Recommended textbooks for you

Fundamentals of Information Systems

Computer Science

ISBN:

9781337097536

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Principles of Information Systems (MindTap Course…

Computer Science

ISBN:

9781285867168

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:

9781305082168

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:

9781337097536

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Principles of Information Systems (MindTap Course…

Computer Science

ISBN:

9781285867168

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Fundamentals of Information Systems

Computer Science