Question

In: Computer Science

Assume that you have a Saudi league player database. In this database, you have a table...

Assume that you have a Saudi league player database. In this database, you have a table containing players’ attributes such as (Name, age, position, etc.) and you decided to add information about players’ agents. Would you represent the agent information as attributes in the player table or would you create an entity set for players’ agents? Justify your answer.  

I need clear answer please don't copy and paste

Solutions

Expert Solution

- Lets assume this is the table for the player which is given to us
Player( name , age , position , gender , address, experience ) ------------------> GIVEN

TODO:
- Now, we need to add the players agent info.


Process:
- Check if the agent is directly an attribute of the player or NOT.
- No, agent is a seperate entity linked by some relationship.
- It means that player and agent are two seperate entities having some relationship between them.
- The relationship here is IS-A relationship.
- It means that X is an agent of Y (example). X is agent, Y is player.

As we can see that there are two independent entities having some relationship between them, thus, there will be TWO table or a new Entity Set for AGENT.


Why did we choose seperate entity for AGENT and NOT ONE?
- Consider a scenario where all the information is stored in single table.
- All the players will be tightly coupled with the agents.
- It means that if a particular agent leaves, we also have to remove the corresponding player entry if it is in a same table.
- The above case is called DELETE ANAMOLY in case of DB Design.

- Now, consider 2 different tables linked via a foreign key in AGENTS table.
- If we want to remove any reference of agent, corresponding to the player, we can easily do so by removing from the entry from the AGENTS table without having to change anything in the PLAYERS table.
- This way we have resolved the DELETE ANAMOLY by creating a seperate entity/table for AGENTS corresponding to the player.



Kindly upvote if this helped


Related Solutions

Assume that you have a Saudi league player database. In this database, you have a table containing players’ attributes
Assume that you have a Saudi league player database. In this database, you have a table containing players’ attributes such as (Name, age, position, etc.) and you decided to add information about players’ agents. Would you represent the agent information as attributes in the player table or would you create an entity set for players’ agents? Justify your answer.
You have a table for a membership database that contains the following fields: MemberLastName,
You have a table for a membership database that contains the following fields: MemberLastName, MemberFirstName, Street, City, State, ZipCode, and InitiationFee. There are 75,000 records in the table. What indexes would you create for the table, and why would you create these indexes?
HR Slugger is a professional baseball player in a Major League Baseball league. He is a...
HR Slugger is a professional baseball player in a Major League Baseball league. He is a well-known player and is very popular throughout the league, but especially with the local fans. Much of his population is based on his hitting ability, specifically regarding home runs. The issue emerges from the following facts, similar to an actual situation you may have heard of. • After days of intense anticipation by sports fans and winters throughout the league, Slugger hits a home...
tableA is a table in a relational database with a composite prime key. You have determined...
tableA is a table in a relational database with a composite prime key. You have determined that the table is 2NF. Owing to the fact that it is 2NF and the key is composite, is it automatically 3NF? Explain your answer. (4 points) Lack of normalization of database tables may cause update, delete, and/or insert anomalies. You have a 2NF table, tableA, in a relational database. Give an example of an anomaly to which tableA might still be subject. Give...
Assume you are creating a database for IS paint store. The database needs to support the...
Assume you are creating a database for IS paint store. The database needs to support the following business functions. • Allow customers to browse the inventory. Customers want to search by paint types and colors. Customers also wants to know pricing information. • A customer can be a regular customer (e.g., home owner), or a contractor or painting professionals. Different customers can get different discounts for the same type of paint. We assume each customer can get the same discount...
Need SQL commands for these questions based on the bowling league database; When was the first...
Need SQL commands for these questions based on the bowling league database; When was the first tournament date and where was it played? What are the number of tournaments per location?
For this part, assume you are entering information about transactions into their relational database. You will...
For this part, assume you are entering information about transactions into their relational database. You will be entering financial information, but you will also need to consider the other types of information Big Marker would want to know about that event. You will also utilize what you have learned to identify internal controls specific to each transaction. The transactions are as follows: a. Billed 30 communities for monthly dues of $600 (each). b. Borrowed $10,000 from First National Bank with...
Suppose the American Cornhole League mandates a minimum salary for each player on the tour. What...
Suppose the American Cornhole League mandates a minimum salary for each player on the tour. What will be the result of this rule? Excess demand for Cornhole players Excess supply of Cornhole players A market equilibrium where supply meets demand Salaries are uncertain
Consider the following relational model for a basketball league: • Player (PlayerID, PName, Position, TeamID) •...
Consider the following relational model for a basketball league: • Player (PlayerID, PName, Position, TeamID) • Team (TeamID, TeamName, Venue) • Game (GameNo, Date, Time, HomeTeamID, AwayTeamID) • Record (GameNo, PlayerID, Points, Rebounds, Assists) In this basketball league, each team has a unique name and each player plays for only one team. One team has at least 10 players. Two teams (home team versus away team) participate in each game at home team’s venue. Each team meets all other teams...
Jason "Sharp Shooter" Averson is a basketball player in the major league. He has a free...
Jason "Sharp Shooter" Averson is a basketball player in the major league. He has a free throw success rate of 0.63. Find the probability that from a random sample of 28 free throws, Jason is successful, i.e. scores, on 18 or more throws. You may find this standard normal table useful. Give your answer as a decimal to 3 decimal places. Probability =
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT