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
Question: In relation to distributed database answer the following questions: (i) Give a brief definition of distributed database. Support your answer with an appropriate di

Define object-relational systems? Systems that give object-oriented extensions to relational systems are known as object-relational systems.

What are the advantages of embedded query language? Give an example of an embedded SQL query. Embedded query language - SQL could be implemented within two ways. It can be us

Record based Logical Models: Use records as the key data representation components Examples: Relational Model: It shows data as well as relationship between data in the form

Explain the Recoverable Schedule A recoverable schedule is one in which for each pair of transactions Ti and Tj such that Tj reads a data item formerly written by Ti, the comm

Describe the Menu based interfaces for web clients or browsing? Menu-Based Interfaces for Web Clients or Browsing - These interfaces present the user along with lists of option

Load sample data into the database tables design and test queries to return the following information • All rows and columns for employees • All rows and columns for customers •

OBJECTIVES After going through this unit you should be capable to: Explain the File Based system and its limitations; Explain the structure of DBMS; Explain the

Write the motivations led to development of OO-DBMS? 1.  Programmer frustration with RDBMSs. 2.  Requirement for special features.

Which is another name for weak entity? Child is another name of weak entity.