The example above doesn’t detail enough related to fields, primary keys, and foreign keys. a. What fields would you add to the member table for example? Hint: Think of the things that we would want to know about members such as contact information, etc. b. What types of information would be important to know about and why? c. And which fields are primary or foreign keys?

The example above doesn’t detail enough related to fields, primary keys, and foreign keys. a. What fields would you add to the member table for example? Hint: Think of the things that we would want to know about members such as contact information, etc. b. What types of information would be important to know about and why? c. And which fields are primary or foreign keys?

CMPTR

3rd Edition

ISBN:9781337681872

Author:PINARD

Publisher:PINARD

Chapter17: Creating A Database

Section: Chapter Questions

Problem 4QY

See similar textbooks

Similar questions

Primary keys and candidate keys may both be assigned to the same attribute.
Second normal form (2NF) states which of the following? All fields must contain single values only. Part of the primary key may not determine a non-key field. A non-key field may not determine a non-key field. In an all-key table, part of the key can determine multiple values of, at most, one other field.
Relational model: In the personal model, data are prearranged in tables, which contain of table. A data in a table is called fields. Fields in a db table are also referred as qualities of a db object. A group of related fields are called as a record, which I also called as db object or entity. A group of records are called a table. Keys in a relational db table refer to a key field. To identify each record in a table, there must be at least one data field that should be unique. That is, a corresponding data field of every record should be unique. Therefore, key field is used to identify the unique record from a collection of records.
Part 1: Use the following schema to answer the questions 1-3 below. This schema refers to a gaming organization. There can be any number of players per game. Each game and each tournament has one winner; if the game or tournament is ongoing, the winner is null. The gameWinner and tournamentWinner attributes are foreign keys for memberID. Member (memberlD, memberName, joinDate) Game (gamelD, gameType, gameDate, gameWinner, tournamentName) MemberGame (memberlD, gamelD) Tournament (tournamentName, tournamentWinner) 1. Write a description of what each of the following queries does: a. SELECT FROM Member LEFT OUTER JOIN Tournament ON memberlD = tournamentWinner; b. UPDATE Member SET memberName = "Devon Chance" WHERE memberID = 100154; C. SELECT memberlD, gamelD FROM Member NATURAL JOIN MemberGame NATURAL JOIN Game WHERE joinDate = "2021-01-01" 2. Write two functionally different relational algebra statements equivalent to the query in 2c.
Part 1: Use the following schema to answer the questions 1-3 below. This schema refers to a gaming organization. There can be any number of players per game. Each game and each tournament has one winner; if the game or tournament is ongoing, the winner is null. The gameWinner and tournamentWinner attributes are foreign keys for memberID. Member (memberlD, memberName, joinDate) Game (gamelD, gameType, gameDate, gameWinner, tournamentName) MemberGame (memberlD, gamelD) Tournament (tournamentName, tournamentWinner) 1. Write a description of what each of the following queries does: a. SELECT memberID, gamelD FROM Member NATURAL JOIN MemberGame NATURAL JOIN Game WHERE joinDate = "2021-01-01" b. Write two functionally different relational algebra statements equivalent to the query in 1a. C. Which of your answers to question 3 will most likely be processed faster? Justify your answer.
Part 1: Use the following schema to answer the questions 1-3 below. This schema refers to a gaming organization. There can be any number of players per game. Each game and each tournament has one winner; if the game or tournament is ongoing, the winner is null. The gameWinner and tournamentWinner attributes are foreign keys for memberID. Member (memberlD, memberName, joinDate) Game (gamelD, gameType, gameDate, gameWinner, tournamentName) MemberGame (memberlD, gamelD) Tournament (tournamentName, tournamentWinner) 1. Write mySQL queries to generate the following tables: a. The total number of ongoing tournaments. b. The average number of players per game of type Power Grid. c. The names (no duplicates) of all players Abigail Baker beat in any game.
Part 1: Use the following schema to answer the questions 1-3 below. This schema refers to a gaming organization. There can be any number of players per game. Each game and each tournament has one winner; if the game or tournament is ongoing, the winner is null. The gameWinner and tournamentWinner attributes are foreign keys for memberlD. Member (memberID, memberName, joinDate) Game (gamelD, gameType, gameDate, gameWinner, tournamentName) MemberGame (memberlD, gamelD) Tournament (tournamentName, tournamentWinner) 1. Write mySOL queries to generate the following tables: a. Each tournament name with the number of games in that tournament won by the tournament winner. b. A list of game IDs and game types sorted by game type then game id. A list of player IDs of all players who have played a game with the date of the first game played by that player. с.
What is the binary relationship?
What is the functional relationship between the main key and a non-key attribute as explained by another non-key attribute?
How do primary key, candidate key, and superkey differ?
Can composite keys include composite attributes?
What is a simple (or atomic) attribute?