A shop is having products which it buys from the supplier and sales it to the customer. The shop gives products on credit and keeps the record of amount due on the customer. The shop maintains the sales records of every purchase, like customer detail, date of purchase, total amount and list of products purchased. The owner of the shop wants a software for his trading business. List the files required to maintain this system and details of data in these files. List down the files required and details of data inside those files, for a university system.Suppose that you are given a relation R = (A,B,C,D,E) with the followingfunctional dependencies: {CE → D,D → B,C →A}.Find all candidate keys.Suppose that you are given a relation R = (A,B,C,D,E) with the following functional dependencies:{BC → ADE, D → B}.Find all candidate keys.You are given the following set of functional dependencies for a relation R(A,B,C,D,E,F),F = {AB → C, DC → AE, E → F}.What are the keys of this relation?Write the SQL command for followingTeams ( Teamcode , Teamname, Clubname, total_member, dateofstart, teammanager,teamcoach)Players (Teamcode, playername, dateofbirth, specialposition, Numberofgoal, number of tournaments, Tshirtno)Tournament (Tournament_code, Tname, Year, Hostcountry, numberofteams, winnerteam, goldenboot)Tournament_teams (Tournament_code, teamcode, totalyellocard, totalredcard, numberofgoals)Matchdetail (tournament_code, Mtcode, Team1code,team2code, winnerteamecode, matchdate ,team1goal,team2goal,refree)Write commands to create the above tables.Teamcode in player table is primary key.Teamcode in players, tournament_Team table is foreign key.Show the players of winner team of the year 2010.Show the team details of the team which got maximum yellocard.Show the team name of the team which won with maximum goal difference with the opposite team in a match.Show the details of the oldest team Write the relational algebra expressions for the following queriesList the players who played more than 5 tournamentsList the teamcode, playername of all the players who play with Tshirtno 7.List all the players of the team whose coach is “Pep Guardiola”.List the

CE->D D->B C->A CD->A Attribute Closure CEA+->CEADBCEB+->CEBDACED+->CEDBA So…

Answered: Suppose that you are given a relation R…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

A shop is having products which it buys from the supplier and sales it to the customer. The shop gives products on credit and keeps the record of amount due on the customer. The shop maintains the sales records of every purchase, like customer detail, date of purchase, total amount and list of products purchased. The owner of the shop wants a software for his trading business. List the files required to maintain this system and details of data in these files.

List down the files required and details of data inside those files, for a university system.

Suppose that you are given a relation R = (A,B,C,D,E) with the followingfunctional dependencies: {CE → D,D → B,C →A}.

Find all candidate keys.

Suppose that you are given a relation R = (A,B,C,D,E) with the following functional dependencies:

{BC → ADE, D → B}.

Find all candidate keys.

You are given the following set of functional dependencies for a relation R(A,B,C,D,E,F),

F = {AB → C, DC → AE, E → F}.

What are the keys of this relation?

Write the SQL command for following
Teams ( Teamcode , Teamname, Clubname, total_member, dateofstart, teammanager,teamcoach)
Players (Teamcode, playername, dateofbirth, specialposition, Numberofgoal, number of tournaments, Tshirtno)

Tournament (Tournament_code, Tname, Year, Hostcountry, numberofteams, winnerteam, goldenboot)

Tournament_teams (Tournament_code, teamcode, totalyellocard, totalredcard, numberofgoals)
Matchdetail (tournament_code, Mtcode, Team1code,team2code, winnerteamecode, matchdate ,team1goal,team2goal,refree)
Write commands to create the above tables.

Teamcode in player table is primary key.

Teamcode in players, tournament_Team table is foreign key.

Show the players of winner team of the year 2010.
Show the team details of the team which got maximum yellocard.
Show the team name of the team which won with maximum goal difference with the opposite team in a match.
Show the details of the oldest team

Write the relational algebra expressions for the following queries
List the players who played more than 5 tournaments
List the teamcode, playername of all the players who play with Tshirtno 7.
List all the players of the team whose coach is “Pep Guardiola”.
List the

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.