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...

1. 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.

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

1. 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.

1. 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.

1. 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?

1. Write the SQL command for following


2. Teams ( Teamcode , Teamname, Clubname, total_member, dateofstart, teammanager,teamcoach)


3. Players (Teamcode, playername, dateofbirth, specialposition, Numberofgoal, number of tournaments, Tshirtno)

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

1. Tournament_teams (Tournament_code, teamcode, totalyellocard, totalredcard, numberofgoals)


2. Matchdetail (tournament_code, Mtcode, Team1code,team2code, winnerteamecode, matchdate ,team1goal,team2goal,refree)


3. Write commands to create the above tables.

Teamcode in player table is primary key.

Teamcode in players, tournament_Team table is foreign key.

1. Show the players of winner team of the year 2010.


2. Show the team details of the team which got maximum yellocard.


3. Show the team name of the team which won with maximum goal difference with the opposite team in a match.


4. Show the details of the oldest team

1. Write the relational algebra expressions for the following queries


2. List the players who played more than 5 tournaments


3. List the teamcode, playername of all the players who play with Tshirtno 7.


4. List all the players of the team whose coach is “Pep Guardiola”.


5. List the