I want u to complete this assignment asap. Purpose: Build a new database with two database tables. 1. Create a new database entitled  CompanyX2. Create the

I want u to complete this assignment asap.

Purpose: Build a new database with two database tables.

1. Create a new database entitled  CompanyX2. Create the following database tables:

Employee- Name, Age, Address, ID,StartDate, EndDate, Phone Number, Department ID

Department-Name, Building Number, Department ID, SquareFeet, Active Status, BudgetAmount

• Set the primary key.• Be sure to set the data types accordingly.• Keep in mind that data should be stored in the optimal form for searching data.• Use camel case notation when naming the fields.• Use the caption field property for the employee table so the names in datasheet view are more user friendly.• Limit the employee’s name fields to 50 characters each.• Create a lookup datatype for the department name. Populate the lookup with four fictitious names of your choice for the user to pick from.• Join the tables. Enforce Referential Integrity.3. Define the following terms/acronyms:

a.      Primary Key

b.      Foreign Key

c.       RDBMS

d.     Referential Integrity

e.      DBMS

f.        Table

g.      Record

h.      Field

i.        Relationship

j.        Input mask

    Upload your database to NEXUS.

4. Add additional table(s) to the JSP Recruiter’s database to accommodate recruiter dependents.  It can be downloaded off the Access section of Nexus.

 It is determined for benefit purposes that we must track each Recruiters family member(s). We should store the person’s name, address, and age. 

 Each recruiter can have many different dependents. A dependent could have many recruiters associated with them to account for things like marriages/family relations.  Implement this in your database. 

Keep in mind the relationship type.Set the primary keys as required.Add foreign key.Build all relationships in the relationship window.

Create one input mask for medical number. Assume the medical number is in this format: 12345, 65665.

Set the field length property for the length of address. Use your judgment as to the proper length. Be sure to set data types accordingly.

Implement a method in the database to make it possible to determine if the relationship between the Dependent and the Recruiter is current/in good standing.

hint- It is done in the new table you should have created.

5. Build a form best suited for each of your tables.

6. Find and save the following via query:a) Find all the Clients who owe more than 10k and are from City Berridge.b) Find Recruiters without clients.c) Count the number of Clients.d) Total the amount paid for all Clients.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

  Module 04 Course Project – Detailed Training Outline or Storyboard  For

  Module 04 Course Project – Detailed Training Outline or Storyboard  For this part of your course project, submit one of the following: If Your Course Project Is Traditional-Based Training: Submit a detailed outline (a minimum of 4 pages) of the training. If Your Course Project Is Technology-Based Training: Submit

Avoiding Wrongful Employee Terminations Overview To be wrongfully terminated is to be

Avoiding Wrongful Employee Terminations Overview To be wrongfully terminated is to be fired for an illegal reason, which may involve violation of federal antidiscrimination laws or breach of contract. The legal standards governing termination differ substantially depending on whether private-sector and nonunion employees or public-sector and unionized employees are being

Find an investigative article related to your topic from either

Find an investigative article related to your topic from either the CPCC Library databases or from the free web (Google, Yahoo, etc). Read the story and summarize/evaluate it on the discussion board (like what you did for your Annotated Bibliography). What was one method of research the author used that

Washington and Du Bois are often described as having a

Washington and Du Bois are often described as having a rivalry, being at odds with one anothers’ approach and philosophy. Watch the following video. Then for this discussion, tell us which of the two men you agree with most and why.

1. How did World War I impact the overall structure

1. How did World War I impact the overall structure and evolution of the American military? 1 1/2 pages references (additional outside references allowed) Allison, W. T., Grey, J., & Valentine, J. G. (2016). American Military history: A survey from colonial times to the present. Routledge, Taylor & Francis Group.  Roark,

Select ONE option and write a minimum of three paragraphs.

Select ONE option and write a minimum of three paragraphs.  1. Visit the Web home page and web site of a manufacturer of interiors products. Research any information available on the site concerning that would be similar to the pricing, ordering, and shipping instructions that would be in a printed

Forms of policing

 Four specific forms of policing were highlighted in this unit. Define two of the forms of policing covered in this unit. Next, compare and contrast these forms of policing from both a social interaction and structural component perspective. Your essay response must be a minimum of 500 words, not counting

I know it’s due in 16 hours but this won’t

I know it’s due in 16 hours but this won’t take long at all. Please dont overbid I will accept the first cheapest one.* Read these 3 and a half pages , https://photos.app.goo.gl/wRfvkaHVVsScRs5X9 , and answer this:  What is the purpose of this document? Why is it a radical document—even

Define giftedness by drawing on one or more theories or

Define giftedness by drawing on one or more theories or models AND justifies services. It should be approx 10-15 pages, formatted in APA style, and include eight or more citations. To be included: What is Gifted – to include the various views on giftedness Why Gifted Services are Necessary –

Your experiences or learning around this topic

CMST &101 – Seminar Reading Notes 2 : for your reading in  Chapter 7 & 8 Chapter Concept Reading Notes in three parts (the third part is an activity based on the readings) Part 1: To get us started in reading the chapter material and prepare us for the Class Discussions you

Before you read Chapter 18, flip through the chapter and

  Before you read Chapter 18, flip through the chapter and choose a work of art that you appreciate the visual qualities and you would hang in your house. Explain why you chose that piece. You are required to create a thread in response to the provided prompt. Each thread must

Lesson Sequence and Rationale – Premium Paper Help

Lesson Sequence and Rationale Length: 2,000 words including the rationale which should be up to 1,000 words In this assignment you will design three sequenced and coherent lesson plans (each plan is for 60 minutes duration) suitable for either a stage 4 or 5 class. For this purpose, you need

Your report should use line

Your report should use line and a half spacing and be suitable for sending to the client as well as for inclusion in the portfolio. Careful attention should be paid to presentation, spelling and grammar, as would be the case if you were paid consultants. Note that each section of

Introduction A. Identify and briefly summarize the topic related to

 Introduction A. Identify and briefly summarize the topic related to psychology, which you will study. B. Summarize articles relevant to the topic you want to research (see the Final Project Guidelines and Rubric for specific details).  C. Hypothesis 1. State your hypothesis. The hypothesis should be logical and appropriate to

Implications of Health Economic Concepts for Health Care Overview In

  Implications of Health Economic Concepts for Health Care Overview In this assignment you will examine how health care professionals and decision makers evaluate health care economics to understand the economic dynamics of health care systems. Consider the complexity of providing health care and the intricate relationship between the fundamentals of