2023 This will be the first of 8 individual assignments that you ll be | Assignment Collections

Computer Science 2023 ACCESS DB homework

2023 This will be the first of 8 individual assignments that you ll be | Assignment Collections

This will be the first of 8 individual assignments that you’ll be doing throughout the semester to 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:

  1. Read through the contents of the Word document named Final DB Project Description. (It’s located in the Class Data Files sub-folder, and it is also provided as the last lesson this week.) This file will provide you with all the information you need to start laying out your final database.
  2. 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.

<font >

  1. 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).

 

 
 

 

We give our students 100% satisfaction with their assignments, which is one of the most important reasons students prefer us to other helpers. Our professional group and planners have more than ten years of rich experience. The only reason is that we have successfully helped more than 100000 students with their assignments on our inception days. Our expert group has more than 2200 professionals in different topics, and that is not all; we get more than 300 jobs every day more than 90% of the assignment get the conversion for payment.

Place Order Now

#write essay #research paper #blog writing #article writing #academic writer #reflective paper #essay pro #types of essays #write my essay #reflective essay #paper writer #essay writing service #essay writer free #essay helper #write my paper #assignment writer #write my essay for me #write an essay for me #uk essay #thesis writer #dissertation writing services #writing a research paper #academic essay #dissertation help #easy essay #do my essay #paper writing service #buy essay #essay writing help #essay service #dissertation writing #online essay writer #write my paper for me #types of essay writing #essay writing website #write my essay for free #reflective report #type my essay #thesis writing services #write paper for me #research paper writing service #essay paper #professional essay writers #write my essay online #essay help online #write my research paper #dissertation writing help #websites that write papers for you for free #write my essay for me cheap #pay someone to write my paper #pay someone to write my research paper #Essaywriting #Academicwriting #Assignmenthelp #Nursingassignment #Nursinghomework #Psychologyassignment #Physicsassignment #Philosophyassignment #Religionassignment #History #Writing #writingtips #Students #universityassignment #onlinewriting #savvyessaywriters #onlineprowriters #assignmentcollection #excelsiorwriters #writinghub #study #exclusivewritings #myassignmentgeek #expertwriters #art #transcription #grammer #college #highschool #StudentsHelpingStudents #studentshirt #StudentShoe #StudentShoes #studentshoponline #studentshopping #studentshouse #StudentShoutout #studentshowcase2017 #StudentsHub #studentsieuczy #StudentsIn #studentsinberlin #studentsinbusiness #StudentsInDubai #studentsininternational