Our Services

Get 15% Discount on your First Order

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

March 25, 2024

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.

Information Systems

Share This Post

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

Related Questions

Module 8 Sustainability in a Global Economy Discussion: Sustainability You have been working on your case study on airline sustainability. Post a summary of

Module 8 Sustainability in a Global Economy Discussion: Sustainability You have been working on your case study on airline sustainability. Post a summary of your findings. Make sure that you include your references and they are written in APA format. Discussions in this course adhere to strict requirements. To receive full credit, your initial

visions and goal SCR Plan Woods 2 School Community Relations Plan Example 2 In Partial Fulfillment of the

visions and goal SCR Plan Woods 2 School Community Relations Plan Example 2 In Partial Fulfillment of the Requirements of EDAD 5313: School and Community Relations Dr. Jerry Stout Southeastern Oklahoma State University Spring I 2022 School Community Relations Plan Vision Statement: At Antlers Public Schools we believe we have

What does aggregate inventory management concerned with

Write a short story (800 words minimum – 1500 words maximum) in which a character, based on real life, is described. Your story should have a proper setting,

Write a short story (800 words minimum – 1500 words maximum) in which a character, based on real life, is described. Your story should have a proper setting, flow, and conclusion. DO NOT use more than

Population Health and Epidemiology · Due 3/9/24 · Points 150 STRENGTHS AND LIMITATIONS OF

Population Health and Epidemiology · Due 3/9/24 · Points 150 STRENGTHS AND LIMITATIONS OF SECONDARY DATA SOURCES In this information age, where data are readily accessible and there is both a great demand for accelerated research projects and strict limitations on research funding, using existing data makes sense. Data used in this

Recommending an Evidence-Based Practice Change Create an 8- to 9-slide

Recommending an Evidence-Based Practice Change Create an 8- to 9-slide narrated PowerPoint presentation in which you do the following (NOTE: This slide count does not include the cover slide and the reference slide(s). I will stop viewing the slides after the 9th slide, so make sure you get the work in with the

Why do you think collaboration is highly encouraged in education? How do you plan to build community as a school counselor using collaboration? This

Why do you think collaboration is highly encouraged in education? How do you plan to build community as a school counselor using collaboration? This discussion question is informed by the following CACREP Standards: 2.F.1.b. The multiple professional roles and functions of counselors across specialty areas, and their relationships with human

1 Literature Review Social Environment of Social Media The purpose of social media is to connect people; therefore, social media inherently is

1 Literature Review Social Environment of Social Media The purpose of social media is to connect people; therefore, social media inherently is an online social environment. It is also helpful that many members who are connected on social media platforms tend to be like-minded peers, so there is often a

Part 1 Create Section 6 of your Supply Chain Process Improvement Proposal: Measurement and Management. Describe how supply chain performance is

Part 1 Create Section 6 of your Supply Chain Process Improvement Proposal: Measurement and Management. Describe how supply chain performance is measured, presenting the various measures used in each organization or function. Part 2 Create Section 7 of your Supply Chain Process Improvement Proposal: Global Supply Chain. Describe international trade

The objective of the term project assignment is to prepare a Bid Proposal for constructing a one-story single family house (MAKU Residence). Students

The objective of the term project assignment is to prepare a Bid Proposal for constructing a one-story single family house (MAKU Residence). Students must approach the assignment from the perspective of a construction contractor attending a bid, and prepare a professional price proposal using their knowledge, skills and common sense.

please review the information. List 16 facts you learned from the video. Explain each fact in 3 to 4 sentences . Attachments

please review the information. List 16 facts you learned from the video. Explain each fact in 3 to 4 sentences . Attachments Cracking the Code ALSO IF YOU DIDN’T FIND THE ATTACGMENT HERES THE LINK

Please see attached for instructions. Thank you! Global Sourcing/Location Decisions Discussion Increased globalization and improved technologies

Please see attached for instructions. Thank you! Global Sourcing/Location Decisions Discussion Increased globalization and improved technologies have resulted in a variety of options for companies to locate their facilities. Facility location decisions affect the efficiency and effectiveness of managing supply chains and can make the difference between profit and loss.

reply to classmate 1 : Being aware of quantity changes over time is important as it helps us to make informed decisions. One example would be in the medical

reply to classmate 1 : Being aware of quantity changes over time is important as it helps us to make informed decisions. One example would be in the medical field, when a baby is born, you track thei

Week 2 Research Proposal Literature Review (Rough Draft) Literature Review Rough Draft The literature review is one of the most important

Week 2 Research Proposal Literature Review (Rough Draft) Literature Review Rough Draft The literature review is one of the most important components, and often the most time consuming part, of a good research proposal. Without the solid foundation of a good literature review, it is difficult to make a strong research proposal. This week, you

Imagine you have been asked by your school principal, along with your colleagues, to prepare a summary statement that represents your educational

Imagine you have been asked by your school principal, along with your colleagues, to prepare a summary statement that represents your educational philosophy which you will share at the next in-service. Create a 325-word summary of your educational philosophy. Include the following in your summary: · 3 key elements of your educational philosophy

There is an ongoing debate on the effectiveness of incarcerating juveniles in secure settings for long periods of time. Some would argue a long separation

There is an ongoing debate on the effectiveness of incarcerating juveniles in secure settings for long periods of time. Some would argue a long separation will interrupt the lure of the criminal activity in the streets. Others contend long-term incarceration allows juveniles to learn more criminal behaviors and take on

Follow these Essay Assignment Guidelines and the Essay Grading Rubric. Consult the Course Syllabus and Canvas and below this assignment description for the

Follow these Essay Assignment Guidelines and the Essay Grading Rubric. Consult the Course Syllabus and Canvas and below this assignment description for the assignment due date. Intergenerational Trauma and Healing provides multinational and multi-ethnic perspectives on the sources, effects, and modes of healing of intergenerational trauma among diverse communities; “Putting Down

This study finds important patterns in mental exhaustion experiences across genders, age groups and leadership ranks within the company. Women, especially those

This study finds important patterns in mental exhaustion experiences across genders, age groups and leadership ranks within the company. Women, especially those who have been working for 2-5 years, ex

Our Services

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

Share This Post

Related Questions

Use Our 6 Free Tools