Questions
You are hired to design a database for a fitness center. As the fitness center is...

You are hired to design a database for a fitness center. As the fitness center is expanding with more than one branch, they want to create a database to keep track of its customers, facilities and employees. Each branch has a unique id and address (building number, street, district, and city). A branch may have more than one facility (e.g. swimming pool, spa, etc.). Each facility must belong to only one branch, and the information for a facility is name and fees. In addition, each fitness branch offers different classes (such as Yoga, Pilates, Zumba, etc.). All classes should be led by at most one trainer, who is an employee.

Employees must work at one and only one branch. Each employee has an id, name, address (building number, street, district, and city) and can have multiple phone numbers. An employee can only be an admin, managing the facility or working as a clerk, or a trainer. An employee cannot be a trainer and an admin because the trainer id compensated an hourly wage while an admin staff paid a monthly salary. Trainers can train individual customers at different time sessions.

A customer must register at one branch. Each customer has a membership number, name (stored as first name and last name), email, and only one phone number. A customer can join more than one class or uses any number of facilities. A customer may also decide to be trained by at most one personal trainer.

Given the above description:

  1. Draw an ERD for the database, identifying the following:
    1. All the entities, attributes and relationships
    2. Primary key and (discriminator in weak entity, if any). Don’t forget each entity has to have PK.
    3. Participation and cardinality constraints. (Explain your choices for two constraints- i.e. identify the words the guided your decision)
    4. Specialization and completeness constraints (if there is an ISA relationship).
  1. Write a schema for two entities and two relationships of your choice. Remember, sometimes a relationship is better not be represented in a separate schema; if this is the case with your chosen relationship explain what you will do.
  2. Please use a tool to draw the ERD exactly draw it use the word microsoft to make it clear answer .

In: Computer Science

NEED Answer for Dedicated Queues please! Problem 15-25 Burger Dome sells hamburgers, cheeseburgers, French fries, soft...

NEED Answer for Dedicated Queues please!

Problem 15-25

Burger Dome sells hamburgers, cheeseburgers, French fries, soft drinks, and milk shakes, as well as a limited number of specialty items and dessert selections. Although Burger Dome would like to serve each customer immediately, at times more customers arrive than can be handled by the Burger Dome food service staff. Thus, customers wait in line to place and receive their orders. Suppose that Burger Dome analyzed data on customer arrivals and concluded that the arrival rate is 45 customers per hour and 1 customer processed per minute.

Compare a multiple-server waiting line system with a shared queue to a multiple-server waiting line system with a dedicated queue for each server. Suppose Burger Dome establishes two servers but arranges the restaurant layout so that an arriving customer must decide which server's queue to join. Assume that this system equally splits the customer arrivals so that each server sees half of the customers. How does this system compare with the two-server waiting line system with a shared queue? Compare the average number of customers waiting, average number of customers in the system, average waiting time, and average time in the system.

If required, round your answers to four decimal places.

Shared single queue Dedicated queues
Number of customers waiting
Average number of customers in the system
Average waiting time minutes minutes
Average time in the system minutes minutes

In: Math

boric acid (monoprotic acid of type HA with ka=5.0x10-5) is titrated against .200m naoh(aq) a) calculate...

boric acid (monoprotic acid of type HA with ka=5.0x10-5) is titrated against .200m naoh(aq)

a) calculate the ph after 20.0ml of .200 m Noah (aq) has been added to 50.0ml of .200m boric acid.

b) calculate the ph at the equivalence point

please show steps thank you

In: Chemistry

1) a. What is the molar concentration (i.e., molarity) of sucrose (C12H22O11) if 150.0 g is...

1) a. What is the molar concentration (i.e., molarity) of sucrose (C12H22O11) if 150.0 g is dissolved in 250.0 mL of solution?

b.What is the molar concentration of methanol (CH3OH) if 125.0 mL is dissolved in enough water to make 15.0 L of solution? The density of methanol is 0.792 g/mL.

c.How many grams of NaOH are contained in 250.0 mL of a 0.400 M sodium hydroxide solution?

d.The drinking water standard for lead is 15 ppb (parts per billion). What is this in M? (See Appendix C – Solution Preparation)

e.What volume of 0.650 M sucrose must be diluted with water to prepare 250.0 mL of 0.423 M sucrose? (See Appendix C – Solution Preparation)

f.Which of the following solutions contains the largest concentration of chloride ions: Which contains the largest number of chloride ions? Show work. a. 100 mL of 0.30 M AlCl3 b. 50.0 mL of 0.60 M MgCl2 c. 200.0 mL of 0.40 M NaC

(SHOW WORK, Expaniton) Thank you.

In: Chemistry

How would you respond to this post? Just in time (JIT) inventory management is a form...

How would you respond to this post?

Just in time (JIT) inventory management is a form of a lean manufacturing strategy for increased efficiency. JIT is an ordering process where the materials are received to manufacturing as they are needed for production (Vonderembse, & White, 2013). By operating under the JIT inventory management practices, the company operates with lower inventory levels and little or no safety stock. Lower inventory levels promote efficiency, lower costs, and less waste. Companies that use JIT process in real time and only produce products which have been planned and ordered by customers. JIT inventory management can be used by large or small companies to provide products with excess waste and improve the process flow. JIT works best for industries with strong economies of scale and even stronger leverage with multiple suppliers supporting their industry. This is why it works so well for manufacturing-based businesses. JIT inventory practices would not be appropriate for smaller scale service-based companies that cannot predict customer orders or forecast plan easily. These companies many include a consulting business, auto dealerships, and bakeries. Some other companies that may not fair well with JIT inventory are companies that are seasonal in nature. Companies such as tax services, lawn services, and florists cannot always predict business levels from previous data due to seasonal changes and unforeseen circumstances. These companies have in common that they are cyclical and the demand for product is not regular in nature.

In: Operations Management

How would you respond to this post? Scheduling is an essential task for any service line....

How would you respond to this post?

Scheduling is an essential task for any service line. Coordination is needed to plan for an effective schedule to ensure products and services are delivered to meet the consumer demand (Vonderembse & White, 2013). In order to create the right schedule, management must consider the expected turnaround time of a product and the number of goods that need to be produced. Restaurants may utilize the method known as chase demand to schedule the most number of workers based on the busiest hours using the historical pattern (Vonderembse & White, 2013). This approach will allow people who may want to work a part-time position to staff the busiest hours and then not have too many employees idle during the rest of the shift. Furthermore, restaurants may install technology, such as self-checkout lanes to reduce the need of labor and re-allocate its staff to perform higher critical-thinking tasks (Nassauer, 2020). Additionally, restaurants and airlines use reservations to know the demand in advance. Airlines can offer the lowest fares for those that are willing to book farthest in advance (Vonderembse & White, 2013). This allows companies to prepare adequately in time whereas hospitals cannot respond to an on-demand approach and adjust capacity easily. However, the hospital may cross-train employees to improve flexibility in scheduling to rotate among existing pool of resources.

In: Operations Management

Select either OSSTMM, PTES, or ATT&CK and explain the importance of using a formal testing methodology....

Select either OSSTMM, PTES, or ATT&CK and explain the importance of using a formal testing methodology. Clearly define what occurs in each phase of your selection and the significance of each phase.

In: Computer Science

How would you respond to this post? In Chapter 11 of Operations Management, Authors Vonderembse &...

How would you respond to this post?

In Chapter 11 of Operations Management, Authors Vonderembse & White (2013), share with the readers many facts on the inventory production system known as Just-in-Time (JIT). This system is widely used in assembly line work, where the many tasks are accomplished in a continuous flow and the inventory is kept at a minimum with little or no waste. Lean process is part of the JIT process where the many steps of production are reviewed and combined or eliminated with results of production times being faster with same turnout of a quality product for the customer. The components of JIT are generating flow, simplified process flow, uncovering problems in inventory, emphasis on quality, and eliminating waste the best a company structure can do so. The steps are to be precise and conducted in a fast turnaround time as customers expect the product in a timely manner for the supply and demand of product has a direct correlation on how much a customer purchases of a product.

The process is commonly see in the automotive industry as they are production line structured. I have seen the process in replacement parts also, the packaging of small parts in the plastic bags then in placed in box of item, motors, book shelves, TV Stands are all examples of JIT. Other business I have seen with this structure are also production lines in baking/dry goods – General Mills, Amazon, and yes even the coffee maker Starbucks are in the JIT – lean business operations.    As for business this would be totally inappropriate, I think of the emergency hospital visit. A hospital has to have the right amount of people and technology (machines) for assistance of an ill person, the personal touch needed for each case cannot be rushed, as a critical diagnosis may be overlooked.   Stock of medications/supplies are needed for more than a week or two, as a disaster in area (such as a tornado) may result in a large number of people in the hospital at one time Yes there is a process in place at the hospital to assist the most people as they can; however, in JIT system, it is not about the person’s well-being, it’s about the numbers while maintaining quality.

In: Operations Management

why is it so important for phsychology to know and understand drug addiction?

why is it so important for phsychology to know and understand drug addiction?

In: Psychology

The level of pesticides found in the blubber of whales is a measure of pollution of...

The level of pesticides found in the blubber of whales is a measure of pollution of the oceans by runoff from land and can also be used to identify different populations of whales. A sample of six male minke whales in the West Greenland area of the North Atlantic found the mean concentration of the insecticide dieldrin to be x = 356 nanograms per gram of blubber (ng/g). Suppose that the concentration in all such whales varies Normally with population standard deviation σ = 54 ng/g. Give a 95% confidence interval for estimating the mean level. (Round your answers to two decimal places.)

In: Math

After reading chapter 5 of the textbook and watching the video “JavaScript Loops” JavaScript Loops and...

After reading chapter 5 of the textbook and watching the video “JavaScript Loops” JavaScript Loops and “JavaScript Decision Statements” 11 JavaScript Decision Statements

Create a html web page that allows the coach of a town’s soccer league to enter the ages of all the children who have registered for soccer this year. Children between the ages of 4 and 15 are allowed to sign up for soccer but there can be a lot of variation in the number of children who sign up each year and their ages. Eventually the children will be placed into one of three leagues: Junior, Intermediate, and Senior. The Junior League is for children ages 4–7, the Junior League is for children ages 8–11, and the Senior League is for children ages 12–15. The coach wants to know how many children will be in each group. Your program should allow the coach to enter the ages of as many children as desired and should keep track of how many are in each group. The final display should tell the coach how many children signed up and how many will be in each group. Save your page as soccer.html and be sure to include an appropriate page title.


Please upload a screenshot of the working program along with a zipped folder with the .HTML file and any other files or pictures.

In: Computer Science

Are sports team names racist or celebratory of Native American peoples? Support your opinion. Consider Thanksgiving...

Are sports team names racist or celebratory of Native American peoples? Support your opinion. Consider Thanksgiving and Independence Day. How might these holidays remind Native Americans of their marginal status?

In: Psychology

choose one of the most dominant InfoSec management models, including national and international standards-based models. What...

choose one of the most dominant InfoSec management models, including national and international standards-based models. What makes this model one of the most dominant? What should be taken into consideration when selecting the most appropriate model or framework for an organization?

In: Operations Management

C++ code a program should prompt the user for the name of the output file. The...

C++ code

a program should prompt the user for the name of the output file. The file should be opened for write operations. Values calculated by the program will be written to this file. The program must verify that the file opened correctly. If the file did not open, an error message should be printed and the user should be prompted again. This should continue until the user supplies a valid filename.

In: Computer Science

how is the continuity of government is ensured at the local level (plans? black helicopters? Act...

how is the continuity of government is ensured at the local level (plans? black helicopters? Act of God?)

In: Operations Management