Databse Project, using Access, ER diagrams

Completed Posted May 1, 2003 Paid on delivery
Completed Paid on delivery

For this assignment, you are to model a portion of real world in an ER-diagram and then implement the model using MS-Access. The particular portion of the real world that you model may correspond to the actual portion of the real world or may correspond to Hypothetical, but realistic, portion of the Real world. Include rules of this mini world, similar in format to the rules given for the company database. On the ER diagram, give (min,max) values to indicate the participation constraints on an Entity type on a relation Type. Then map the ER diagram to the Relation database Schema (A set of relation schemas). Load the database with the actual data and then create at least 12 SQL queries, ranging in complexity from simple to sophisticated. In addition to those stated above, this assignment has the following requirements. (1) The ER diagrams should have at least 6 non-week entity types and at least one week entity type. It should include at least one 1-1 relation type, four 1-many relation types and atleast one many-many relation types. It should include atleast one multi valued attribute. (2) Among your atleast 12 SQL queries, you should have - Atleast 5 nested queries. - Atleast 4 different aggregate functions with the Group by feature. - Atleast 4 queries involving the existence of certain values. - Atleast 2 queries involving the date attribute (other then in the select clause) - Atleast 2 queries involving the Having clause. - Atleast 1 query involving the Union operation. (3) atleast 2 Forms should be created for the purpose of inputting data into 2 of the tables. (4) Atleast 2 Reports should be created, the reports should contain Aggregate and summary information about the database. (5) Atleast 2 Macros should be created for whatever useful purpose, you deem appropriate. Please turn in the following: - A type description of the rules of the mini world u r modeling. - ER diagram - Relation Schemas, Underlining Primary keys. - Under each

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.

## Platform

Access

Article Rewriting Engineering Microsoft Access MySQL PHP Research Writing Software Architecture Software Testing Translation

Project ID: #2930891

About the project

6 proposals Remote project Active May 4, 2003

Awarded to:

abhijitsathe

See private message.

$12 USD in 14 days
(7 Reviews)
1.7

6 freelancers are bidding on average $12 for this job

teamvw

See private message.

$12.75 USD in 14 days
(36 Reviews)
3.8
lubnavw

See private message.

$12.75 USD in 14 days
(10 Reviews)
3.8
stolevw

See private message.

$8.5 USD in 14 days
(28 Reviews)
2.6
imidebest

See private message.

$12.75 USD in 14 days
(7 Reviews)
2.5
vw811007vw

See private message.

$12.75 USD in 14 days
(4 Reviews)
2.5