Create your relationships and populate your tables

Assignment Help Basic Computer Science
Reference no: EM13974168

ACCESS DB

Do Database Project Assignment.

In this assignment, you're going to do the field definitions, create your relationships, and populate your tables with data. It is extremely important that your tables be set up correctly, because all future assignments will depend on your having the correct number of records. So please pay close attention to what you end up with in your tables.

I have provided all of the data in the form of an Excel file, for you to transfer into your database, so you won't have any data-entry to do. Please make sure the data are being transferred in correctly. If an Excel worksheet has 25 records and you're transferring those data into your Access table, your Access table should end up with 25 records. (I know this is a "Duh" thing to say, but I have to mention it nonetheless. Stay awake while doing this! In previous semesters there were cases where the tables looked OK initially, but when we got to queries and reports, suddenly the wrong number of records were showing up. And this went back to the contents of the source data in the tables.)

Here's the assignment:

Based on the plan you developed in Assignment #1 for Week 4, create all of the tables for the database. Be sure to use the Leszynski Naming Convention for all table names.

Define all fields. Just set the properties specified below. Again, be sure to use the Leszynski Naming Convention for all field names.

Set captions for all fields.

Create all necessary and appropriate relationships.

Populate the tables with the data that are provided in the Excel workbook named Final Project Data.xls.

The name of your database will be Final DB Week x.

Attachment:- Database Project.rar

Reference no: EM13974168

Security and compliance

Security and compliance are interconnected in important ways. What happens if you have a policy, but you cannot assure compliance? There is no automated enforcement mechanis

Determine the minimum diameter of the duct

The air in a 6-m × 5-m 3 4-m hospital room is to be completely replaced by conditioned air every 15 min. If the average air velocity in the circular air duct leading to the

Summarize the details of the selected case

From the e-Activity, summarize the details of the selected case, and indicate the end result. Determine whether or not you believe this type of crime could be created withou

Discuss ways to prevent node capture in sensor networks

Encryption is very difficult to implement in sensor networks. However, there have been several papers exploring limited ways of doing this. Look for one or two papers and di

What the router does with a packet addressed

Suppose a router has built up the routing table shown in Table 4.14. The router can deliver packets directly over interfaces 0 and 1, or it can forward packets to routers R2

Show your structure definition code

Which fields in a log entry will be accessed for the given log processing function? Assuming 64-byte cache blocks and no prefetching, how many cache misses per entry does th

Develop a recursive implementation

Develop a recursive implementation that incorporates the ideas above for calculating the Fibonacci number. Compare the performance of the recursive method with the iterative s

Describe any boundary conditions

Note that the intersection of two lists is a new list containing the elements that the two list have in common, without modifying the two original lists. Describe any bounda

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd