database design, Database Management System

Build a database application for a sports league. Assume your application is to keep track of teams and equipment that is checked out to teams. Explain the steps that is needed and to be taken to develop this application. Specify entities and their relationship. Build an E-R Diagram. Ensure diagram shown minimum and maximum cardinalities. Transform your E-R diagram into a relational design.
Use access to implement your data base design. Create the tables and add sample data. Create a data entry form that shows teams and the equipment they have checked out. Verify that the form correctly processes new check outs, changes to check outs and equipment returns. Create a report that shows each team, the items they have checked out, and the the number of items they have checked out.
Posted Date: 3/23/2013 9:04:21 PM | Location : United States







Related Discussions:- database design, Assignment Help, Ask Question on database design, Get Answer, Expert's Help, database design Discussions

Write discussion on database design
Your posts are moderated
Related Questions
Project Description: Critical Project for VMware Technical support. VMWare ESXi 5.1 support for upgradation and migration problem. Technical expert of Vmware needed. Sk

What are the uses of the information in the Data dictionary? The following information is directly taken from the Data dictionary: Information on fields displayed with


Why did SAP introduce the extended star schema? Explain why it is reported to be better than the traditional schema model?

List the steps for converting state diagram to the code. a) Finding major control path b) Finding the conditional statements  c) Finding the loops  d) Finding error ro

What is RDBMS? Relational Data Base Management Systems (RDBMS) are database management systems that maintain data records and indices in tables. Relationships may be formed and

1. Which relational algebra operations do not need the participating tables to be union-compatible? Ans: Join is the relational algebra operations that do not need the particip

Define Deadlock detection If a system does not employ a few protocols that make sure deadlock freedom, after that a detection and recovery scheme should be used. An algorithm

What is Structured Query Langauge (SQL)? SQL is a powerful set-oriented language which was formed by IBM research for the databases that adhere to the relational model. It havi

What are the two approaches to store relations in distributed database? a) Replication b) Fragmentation