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

select a value stream in your organization that can benefit

select a value stream in your organization that can benefit from analysis and improvement. The value stream (or end-to-end process) selected does not need to be overly large or complex. Select something that has the potential for meaningful improvement but is manageable within the scope of this assignment. Develop a

Infrastructure Review As a nurse executive leader, you may very

  Infrastructure Review As a nurse executive leader, you may very well be tasked with the evaluation of the current technology safeguards, infrastructure, and regulations surrounding the security of the enormous amount of patient data collected in your organization. As nursing continues to increase point-of-care clinical technology, there is potential

write a 1-2 page memo (not including references page) to

write a 1-2 page memo (not including references page) to the CIO that identifies more than seven success criteria for implementation of enterprise systems, for the category of enterprise systems assigned to your group (ERP, SCM, CRM, etc.).   1.  Each of these success criteria should be briefly explained and

Please respond to the following: From the Discussion Preparation, compare

Premium Paper Help is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along with research materials for assistance purposes only. All the materials from our website should be used with proper references.

Great Service Cleaning and Maintenance Company

Description Submit a written paper which is at least 2 pages in length, exclusive of the reference page. Papers should be double spaced in Times New Roman font which is no greater than 12 points in size. The paper should cite at least one source independent of the textbook. In

Deliverable length: 400-600 Words Primary Task Response: Within the Discussion

Deliverable length: 400-600 Words  Primary Task Response: Within the Discussion Board area, write 400–600 words that respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and clear, and use examples to reinforce your ideas. You

White P….r for an External Audience Should focus on the

White P….r for an External Audience Should focus on the industry trend for government and large businesses migrating their current information system to a cloud computing option and why small businesses should join the trend. 1200-1600 words Single Spaced Cite in APA Style five sources, one is provided   KARAGOZLU,

1. Please use your won words to write 240 words

1. Please use your won words to write 240 words to answer Discussion Question ( SEE ATTACHMENT) (USE AT LEAST 1 APA FORMAT REFERENCE) 2. Please use your won words to reply 80 words to a classmate answer ( I will post later) 3.Please use your won words to write

  Please read the Chris Peterson at DSS Consulting case, which

  Please read the Chris Peterson at DSS Consulting case, which can be found under eReserves. Solve the case study by analyzing what is presented and stating which specific actions best resolve major issues. These actions must reflect information in the case and the environment facing the firm. Paper should

Disability expert paper on Dyslexia

 You are to research the diagnosis (dyslexia) of the child and write minimally a 4-5 page paper that includes and expands on the following elements: definition of disability characteristics of disability causes of disability how the disability is diagnosed interventions/treatments/common adaptations for the disability other pertinent information (Defined as other

For this week’s assignment you will write the Research Design

For this week’s assignment you will write the Research Design section of your thesis. At this point you will have identified an appropriate research design as a result of writing your literature review and reading the material in this week’s lesson. The following description for this section of your thesis

  This week, we learned about prisoner’s rights and special prison

  This week, we learned about prisoner’s rights and special prison populations. For your Unit 4 Complete assignment, write a narrative essay (minimum 1200 words) in which you address and discuss the questions and statements listed below. Use at least three scholarly sources and remember to demonstrate a thorough understanding

Compile a comprehensive marketing plan

Unit IV Essay Marketing Plan: Part II Throughout this course, you will compile a comprehensive marketing plan using one of the product/service scenarios listed in the Unit II assignment. (Note: You will use the same scenario throughout the course.) This scenario will be the basis of your start-up company and

Case: Select an organization in health care and review the

Case: Select an organization in health care and review the organizational, reimbursement, accounting, and  delivery of care issues or problems they are facing and address the following; 1. Provide an overview. 2. Explain the issues, concerns, problems, etc. 3. Determine best course of action to solve the problem (s). 4.

In this Assignment, you are a criminal justice practitioner with

  In this Assignment, you are a criminal justice practitioner with 5 years of experience. You have been asked by your supervisor to prepare a PowerPoint presentation (with slide notes) for recent academy graduates on ethical challenges in the criminal justice field. The (MSCJ) Assignment: Using the Walden University PowerPoint

Presence of Urine in the blood.

The following job is another student post to wish i have to react. Please add some other information about the topic. do not repeat the same as the student already did. remember APA. and less than 20 % of similarity.   CHAPTER 42 a) When a person is suffering from