Determine which relationships will need to be created

Assignment Help Basic Computer Science
Reference no: EM13972958

ACCESS DB homework

Create your own database. These assignments will be handed in and graded, as will the final version of the database.

This assignment is extremely important, because you need to make sure your database is designed correctly before you start actually creating it and populating it with data. So please spend an adequate amount of time on this.

NOTE: This is the first Final Database assignment, but it's the second assignment of this semester. Therefore, the name that you will need to attach to the file will reflect the number of the week. See below for the precise naming method I would like you to use.

Here's the assignment:

Based on the objectives described in the Final DB Project Description, plan out your database.

Decide how many tables you will need, and which fields will be in each one of the tables. Make absolutely sure your tables are fully normalized, so that there is no redundancy.

Specify the data type for all fields. Use the Leszynski Naming Convention for all table and field names.

Determine which relationships will need to be created, as well as the type of relationship. Clearly indicate the type (i.e., One-to-One, One-to-Many) for all proposed relationships. You should avoid Many-to-Many relationships for this database. That type of relationship falls outside the parameters of this class and isn't necessary in this file.

Decide which fields will be the primary key fields and which ones will be the foreign key fields of the different proposed tables.

Indicate which fields will be connected to which fields in the relationships. Make sure it is clear to me when I look at your tables which fields will be connected to which other fields, as well as what you are proposing as the type of join.

The best way to do this would be by drawing lines to connect the fields. If you do this in Excel or Word, you can use the Line tool (available on the Drawing toolbar) or one of the AutoShapes (also on the Drawing toolbar), or you can simply write out a description of the different relationships. Regardless of your method, make sure I understand your objectives with regard to the different relationships that you're proposing.

The following sample, which I did in Excel, will give you an idea of what I would consider to be a clear idea of how you would design the database. This example deals with a project database that keeps track of employees and the projects they're working on. Notice how the following items are clear from this description:

The name of each table, with the Leszynski prefix.

The name of each field, with the Leszynski prefix. (The field name prefix will tell me what you're proposing for the field type - Text, Currency, Date/Time, Number, etc.) (Remember that num is not the prefix we use for Number fields.)

The proposed primary and foreign key fields in each of the tables.

The type of relationship that will join each set of tables.

Hand in your table designs in either a Word or Excel document. Name the file <Your First Name> Week 4 Final DB. I do not want this handed in as an Access file.

I should warn you here: I really need you to name your files using this naming convention. If your files aren't clearly named, I will keep bugging you about it (as some of you have witnessed with last week's assignment).

Attachment:- Project_Data.xls

Reference no: EM13972958

How versatility-microsoft excel affect application support

How does this versatility of Microsoft Excel affect application support? With this versatility and possible customization what assumptions must be made

Determining the efficiency analysis

Baryla Inc. manufactures high quality decorator lamps in a plant located in eastern Tennessee. Last year the firm had sales of $93 million and a gross profit margin of 45 pe

How can nanotechnology and nanocomputing benefit us

What is nanotechnology? What are nano computers? How can nanotechnology and nanocomputing benefit us? How might it harm us? What kinds of ethic challenges do research in nan

Write a pseudocode for deleting a node from a bst

Write a pseudocode for deleting a node from a BST. Simulate your algorithm with a BST of 10 nodes and show the deletion process. Especially show the deletion of the interior

Examine the challenges associated with searching in textual

Your company has been hired to design a product that will provide searches of textual documents and database querying. Your design team has not developed a product like this

What are the problems of existing technologies

What is the technology you identified and what are the purposes and uses of this technology? What are the problems of existing technologies and how will the new technologies s

Main reasons why visualization technologies are important

Determine the main reasons why visualization technologies are becoming an important part of organizational success. Select two (2) such technologies related to information s

What are the shingles in the first sentence

If we use the stop-word-based shingles of Section 3.2.4, and we take the stop words to be all the words of three or fewer letters, then what are the shingles in the first se

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