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
Consider the subsequent relations along with keys underlined Street (name, location, city) House (number, street_name) Lives (name, house_number) Define the above relations

give some example real life situation where DBMS are most suitable

how to prepare a data dictionary for online examination system for certified courses?

#Use the following database schema: 1) Patient—PatientID, Name, DOB 2) Doctor—DoctorID, Name, MedLicenseNumber, Phone 3) Medication—MedicationID, BrandName, GenericName 4) Prescrip

What is an ER diagram? Why is it used in Database management system (DBMS)?

What is called mirroring? The simplest approach to introducing redundancy is to duplicate each disk. This method is called mirroring or shadowing.

What is the purpose of storage manager? The storage manager is responsible for the following a) Interaction with the file manager b) Translation of DML commands in to low

To eliminate duplicate rows (distinct operator)  Example: SELECT DISTINCT DEPTNO FROM EMP;

In an E-R diagram an entity set is represent by? In an E-R digram entity set is represted by rectangle.

Explain the two types of participation constraint.  Total: The participation of an entity set E in a relationship set R is said to be total if each entity in E participates i