A Guide to SQL
A Guide to SQL
9th Edition
ISBN: 9781111527273
Author: Philip J. Pratt
Publisher: Course Technology Ptr
Expert Solution & Answer
Chapter 2, Problem 11RQ

Explanation of Solution

Functional dependencies:

Functional dependency is a term in the relational database theory which refers to a constraint that is located in between the two sets of attributes in a relation from a database. The functional dependencies are as follows...

Explanation of Solution

Database:

The given database comprises of the following tables with the respective columns as shown below.

  • DEPARTMENT – DEPARTMENT NUM, DEPARTMENT_NAME
  • ADVISOR – ADVISOR_NUM, ADVISOR_LAST_NAME,ADVISOR_FIRST_NAME,DEPARTMENT_NUM
  • COURSE – COURSE_CODE, DESCRIPTION
  • STUDENT – STUDENT_NUM, STUDENT_LAST_NAME,STUDENT_FIRST_NAME, ADVISOR_NUM

Relations:

The term relation refers to the relationship between the data represented in row-column format...

Program Plan Intro

Entity Relationship Diagram (ERD):

Entity relationship diagram is basically a picture or snapshot about the business system. It means that the information stored and created is represented by this diagram.

  • Entities may represent the physical object, event, or concept.
  • An attribute is a property of an entity.
  • Relationship denotes the link between the entities.
    • If an independent child entity is present in a relationship then it is called a non-identifying relationship.
    • If a dependent child entity is present in a relationship then it is called a non-identifying relationship.

Blurred answer
Students have asked these similar questions
Suppose we have a database for an university. The requirements are as follows: • 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.   The FDs for the above requirements are given as, • PSSN →…
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).Construct the ER diagram for the NHL database using the Crows Foot notation.
So I have this HW question..... "Suppose you are given the following requirements for a simple database for the National Football League (NFL): the NFL 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 set of injury records, · a team captain is also a player, a game is played between two teams (referred to as Home Team and Guest team) and has a date (such as May 11th, 1999) and a score (such as 4 to 2)" And managed to seperate the attributes & entities into this: Team Name City Coach Captain(referenced from Player(Name)) Set of Players Player Name Position Skill Level Set of Injury Records Team (to which the player belongs referenced from Team(Name)) Injury Record Player (to whom the record belongs referenced from Player(Name)) Injury Type Injury Date Recovery Date Game Home Team Guest Team Date Score…
Knowledge Booster
Similar questions
  • Access path A database table is composed of records and fields hold data. Data is stored in records. A field is a part of a record and contains a single piece of data for the subject of the record. The access path for finding the list of books is AUTHOR: AuthorID, Lname BOOKAUTHOR: AuthorID, ISBN BOOKS: Pubdate, ISBN
    The following tables provide a very small portion of the data that will be kept in the database. These data need to be inserted into the database for testing purposes. Write the INSERT commands necessary to place the following data in the tables that were created in Problem 65. RENTAL RENT_NUM RENT_DATE MEM_NUM 1001 01-MAR-13 103 1002 01-MAR-13 105 1003 02-MAR-13 102 1004 02-MAR-13 110 1005 02-MAR-13 111 1006 02-MAR-13 107 1007 02-MAR-13 104 1008 03-MAR-13 105 1009 03-MAR-13 111 VIDEO VID_NUM VID_INDATE MOVIE_NUM 54321 18-JUN-12 1234 54324 18-JUN-12 1234 54325 18-JUN-12 1234 34341 22-JAN-11 1235 34342 22-JAN-11 1235 34366 02-MAR-13 1236 34367 02-MAR-13 1236 34368 02-MAR-13 1236 34369 02-MAR-13 1236 44392 21-OCT-12 1237 44397 21-OCT-12 1237 59237 14-FEB-13 1237 61388 25-JAN-11 1239 61353 28-JAN-10 1245 61354 28-JAN-10 1245 61367 30-JUL-12 1246 61369 30-JUL-12 1246
    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…
    Recommended textbooks for you
  • A Guide to SQL
    Computer Science
    ISBN:9781111527273
    Author:Philip J. Pratt
    Publisher:Course Technology Ptr
    Fundamentals of Information Systems
    Computer Science
    ISBN:9781337097536
    Author:Ralph Stair, George Reynolds
    Publisher:Cengage Learning
    Database Systems: Design, Implementation, & Manag...
    Computer Science
    ISBN:9781305627482
    Author:Carlos Coronel, Steven Morris
    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
    Oracle 12c: SQL
    Computer Science
    ISBN:9781305251038
    Author:Joan Casteel
    Publisher:Cengage Learning
    Fundamentals of Information Systems
    Computer Science
    ISBN:9781305082168
    Author:Ralph Stair, George Reynolds
    Publisher:Cengage Learning
  • A Guide to SQL
    Computer Science
    ISBN:9781111527273
    Author:Philip J. Pratt
    Publisher:Course Technology Ptr
    Fundamentals of Information Systems
    Computer Science
    ISBN:9781337097536
    Author:Ralph Stair, George Reynolds
    Publisher:Cengage Learning
    Database Systems: Design, Implementation, & Manag...
    Computer Science
    ISBN:9781305627482
    Author:Carlos Coronel, Steven Morris
    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
    Oracle 12c: SQL
    Computer Science
    ISBN:9781305251038
    Author:Joan Casteel
    Publisher:Cengage Learning
    Fundamentals of Information Systems
    Computer Science
    ISBN:9781305082168
    Author:Ralph Stair, George Reynolds
    Publisher:Cengage Learning