Reference no: EM13330871
DATABASE DESIGN
March Madness is just around the corner. The following exercise is a way of ushering in the popular event.
The Edinburg County Basketball Conference (ECBC) is an amateur basketball association. Each city in the county has one team as its representative. Each team has a maximum of 12 players and a minimum of 9 players. Each team also has up to three coaches (offensive, defensive, and physical training coaches). During the season, each team plays two games (home and visitor) against each other teams. Given those conditions:
a). Identify all entities that have a direct bearing on the database design in the problem
b) Describe all the business rules that apply to this problem (relationship and constraint). Using the relationship business rules, establish the correct relationships (1:1, 1: M, M: N) between the entities.
c). Draw a complete and correct ER diagram using VISIO. Show at least the PK and FK fields in the diagram. Are you making any valid assumptions? List your assumptions clearly. You must resolve any M: N relationships if any exist. (You must use VISIO to draw the ERD).
d). Using Microsoft Word or Access or SQL Server, convert the entities in the above ER diagram into relevant tables with some realistic fields (columns). Insert some realistic made-up data (records) into the tables to validate your ER diagram.
Attachment:- ASSIGNMENT.rar
|
What are basic issues in training policy
: What are basic issues in training policy? Dicuss some psycological principles followed in training?
|
|
Calculate how deep is the pool
: A point source of light lies at the bottom of a large pool of water. How deep is the pool
|
|
Show the market equilibrium point on the graph
: Using the following demand schedule and a graph sheet plot the demand and supply curves? Also, show the market equilibrium point on the graph. And what is the market equilibrium quantity?
|
|
Calculate the following from the given information
: Quantity and cost of both things are given in the table. Calculate the following from the given information:
|
|
Identify all entities that have a direct bearing on database
: Describe all the business rules that apply to this problem (relationship and constraint). Using the relationship business rules, establish the correct relationships (1:1, 1: M, M: N) between the entities.
|
|
Find its rotational kinetic energy
: A propeller is modeled as five identical uniform rods extending radially from its axis. what is its rotational kinetic energy
|
|
Quantities of specific goods and services
: As an employee of the World Bank, you have been asked to research 1 economic concern in an Asian country and write a report on your findings.
|
|
What is the mass of the planet newtonia
: On the planet Newtonia, a simple pendulum having a bob with a mass of 1.33kg and a length of 186.2cm takes 1.45s , when released from rest, What is the mass of the planet Newtonia
|
|
Analyze requirement for the profession of auditing
: Analyze the requirement for the profession of auditing and the integral role that independence assurance plays within the economy and examine the corporate governance of audits including the professional, regulatory, and corporate managerial requir..
|