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
Write the syntax of creating an INDEX ? Syntax of Creating an Index: CREATE [BITMAP] [UNIQUE] INDEX ON ( [, ] . . .);

Express the subsequent query in SQL assumes which the data is stored within EMPLOYEE table with relevant fields (i) Display name, job, salary, and hire date of employee who are

What are the reasons for having variable length records? What are the various ways to store variable length records? Variable-length records arise in a database in various wa

What is Identity? Identity (or AutoNumber) is a column that automatically produces numeric values. A start and increment value can be set, but most DBA leave these at 1. A GUID

What are the advantages of using a DBMS? The benefits of using a DBMS are a) Controlling redundancy b) Restricting unauthorized access c) Giving multiple user interfac

Lock Based Protocol A lock is nothing but a mechanism that tells the DBMS whether a particular data item is being used by any transaction for read/write purpose. As there are t

Question : (a) Database Management Systems (DBMS) is the foundation of business intelligence. Explain the following concepts related to DBMS: (i) Entity Relationship Diagr

1.  Define each of the following IN YOUR OWN WORDS: (a)   File: (b)   Record: (c)   Field: (d)   Primary Key: (e)   Secondary Key: 2.  A travel agency wants t

Step 1 . Using Oracle, create the tables identified in the preferred solution for Assignment 2. Technicians (ZipCode, TechnicianID, FirstName, LastName, Street, City, State, Home

Define about the Stored Procedure - It's a set of T-SQL statements combined together to perform a single task formed by combining numerous small tasks. - When you essentiall