Computers and Technology, 19.11.2019 06:31 dsaefong00

2. consider the following normalized relations for a sports league and assume that the database is global in scope and covers thousands of leagues, tens of thousands of teams, and hundreds of thousands of players. team(teamid, teamname, teamlocation, teammanager, teamleague)player(playerid, playerfirstname, playerlastname, playerdateofbirth, playerspecialtycode, teamid)specialty(specialtycode, specialtydescription, salary)location(locationid, cityname, citystate, citycountry, citypopulation) manager(managerid, managername)league(leagueid, leaguename, leaguelocation)a. do you see any denormalization opportunities? b. what are the first steps that you can take to improve the performance of the database? c. specify the types of indexes you would recommend for each of the following situations: 1. reporting players by team using the team name 2. reporting players of a specific specialty using the specialty code. how is your answer different if the report is using specialty description as input? 3. reporting the players whose salary is above a specific value. 4. reporting teams and their players by cityd. do you see any partitioning opportunities based on the above queries?

Answers: 2

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 20:00

How is the number 372 written when expanded out to place values in the base 8 (octal) number system? a. 2 x 4 + 3 x 2 + 4 x 1 b. 3 x 64 + 7 x 8 + 2 x 1 c. 3 x 8 + 7 x 7 + 2 x 6 d. 3 x 100 + 7 x 10 + 2 x 1

Answers: 1

Answer

Computers and Technology, 23.06.2019 14:30

Select the correct answer. andy received a potentially infected email that was advertising products. andy is at risk of which type of security threat? a. spoofing b. sniffing c. spamming d. phishing e. typo-squatting

Answers: 2

Answer

Computers and Technology, 23.06.2019 15:20

An ou structure in your domain has one ou per department, and all the computer and user accounts are in their respective ous. you have configured several gpos defining computer and user policies and linked the gpos to the domain. a group of managers in the marketing department need different policies that differ from those of the rest of the marketing department users and computers, but you don't want to change the top-level ou structure. which of the following gpo processing features are you most likely to use? a, block inheritance b, gpo enforcement c, wmi filtering d, loopback processing

Answers: 3

Answer

Computers and Technology, 23.06.2019 18:00

Which finger presses the h key on the keyboard? index finger on the left hand pinky finger on the right hand index finger on the right hand thumb on the left hand

Answers: 1

Answer

You know the right answer?

2. consider the following normalized relations for a sports league and assume that the database is g...

Questions