Company Database assignment help

computer science


Choose a company, school, organization, or other entity (real or imagined) that could

use a database to manage its information. For this entity, create a Microsoft Access

database that has the following characteristics:

 At least 4 tables containing 5 to 10 records each

 Tables should have an adequate number of fields to demonstrate the characteristics

of each record. For example, there would be many more fields in the Student Master

table than were shown in class.

 In the description area in the table design view, explain why you chose the data type

for each field in the table.

 Each table should have a primary key and any related tables should have a primary

and foreign key, and be linked in the relationship window

 Each field should have an appropriate data type considering its purpose and

minimizing the size of the database

 At least two queries that would be useful to users, one of which must be a parameter

query (i.e. it asks for a value to limit results)

 At least one report that would be useful to users. The format created by the report

wizard is acceptable, although you may earn extra points for making it look better.

 A short description of the organization you chose and the purpose of the database

should be include in the Comments section in the database properties.

Related Questions in computer science category

The ready solutions purchased from Library are already used solutions. Please do not submit them directly as it may lead to plagiarism. Once paid, the solution file download link will be sent to your provided email. Please either use them for learning purpose or re-write them in your own language. In case if you haven't get the email, do let us know via chat support.