Represent the above as a single Entity Relation model. Provide any assumptions necessary to support your model
Q: The StayWell maintenance team wants to minimize the number of planned visits to properties. The team…
A: According to the information given:- StayWell maintenance team wants the minimum number of planned…
Q: Challenge Day The Day of Challenge is one of the favorite social sport events of people since 1991.…
A: Code: #include <iostream>using namespace std;int main() { int n; cin>>n; int…
Q: Project: Covid-19 Vaccination Appointment Group members: 1 You need to follow the MVC architectural…
A: An application server that hosts servlets is a server that hosts an application accessed via a…
Q: Q 1: A company named ABC hired three employees in different years; each employee gets an increment…
A: The program is given below: 1) Here for loop is used that will take information from the user,…
Q: Provide Implementation for the requirements mentioned below: 1. Look at the form below, it consists…
A: The main objective of the java program, GUI.java display a window with text boxes for Name, Email,…
Q: ) Create a structure called Patient with the following members: Registration_Number, Name, Age,…
A: Program plan:- Using the header file. Defining Patient structure. This function adds the patient.…
Q: Q1. Consider the following system: A school wants to automate their attendance taking. Attendance…
A: The single use case diagram for the given scenario is split into 4 sub use case diagrams based on…
Q: Durian & Co has five salespersons who sell three different types of durians. Once a day, each…
A: Given:
Q: ake VARCHAR2(20), ppID NUMBER(3), CID NUMBER(3), lue NUMBER(6,2), te_purchased DATE, ONSTRAINT…
A: I have written the query below:
Q: Name P ld Ownerid Property has Owner Address Contact Zipcode City State
A: Part(1) Degree of relationship is basically the number of entities that in general participates in…
Q: Draw the domain class diagrams Scenario: Lillian’s Auto Works Lillian is the owner of Lillian’s…
A: The given problem has described Lillian’s Auto Works, an auto repais company with all the data…
Q: Calculate and display the shares on the screen for a member Calculate and display the deposits on…
A: Summary:We can define a user-defined function to calculate the shares after paying interests and…
Q: Make a use-case diagram, write use-case description (fully dressed) of any 3 use-cases - selected…
A: Note: As per the policy we can answer only single question at a time so i am providing the use case…
Q: Rent-a-Car is a car rental company with a large fleet of cars and it offersshort term rentalto both…
A: Required : ER model with all relations and cardinalities ER MODEL : ER model stands for an…
Q: oop using c++ please give me full answer thanks Write a program to declare a class ‘Result’ which…
A: Note: Comments are mentioned in the code for understandability. Code: #include<iostream>…
Q: . Display the name (first name and last name) for those employees who gets more salary than the…
A: As per the guidelines of bartleby we are allowed to solve three parts please post other parts…
Q: tblMembers The tblMembers will be used to store the details of the Gym Members MemberID, Name,…
A: Given:- 1.1 tblMembers The tblMembers will be used to store the details of the Gym Members MemberID,…
Q: A car dealership wants to have a system to keep the records of all its cars. We already had some…
A: public class Car{ //declaring all instance variables private String make; private String model;…
Q: The State of New York certifies firefighters through- out the state and must keep track of all of…
A: Introduction: A relational database model provides a way of organizing related data and information…
Q: Overview: COVID-19 cases have been increased in the last period. As a result, Ministry of Health has…
A: “Since you have asked multiple questions, we will solve the first question for you. If you want any…
Q: AuctionBase In this project, we are developing an online e-commerce website (similar to eBay). You…
A: the solution is an given below :
Q: Create a role and a user. Assign the role to the user. The role must be assign with all the admin…
A: Usage the GRANT declaration to provide privileges to a detailed user or role, or to entirely users,…
Q: Overview: COVID-19 cases have been increased in the last period. As a result, Ministry of Health has…
A: “Since you have asked multiple questions, we will solve the first question for you. If you want any…
Q: App in JavaScript in Angular js Design, Develop and Deploy a Form with the following Inputs (and…
A: <div ng. Controller=``ExampleController``> <``From novalidate class=simple -form``>…
Q: Write a form program in PHP that prompts a user to enter seven different fields of data, using a…
A: As per bartleby we answer only first question.For more questrion please ask them separately.
Q: 6. Cell Phone Packages Cell Solutions, a cell phone provider, sells the following packages: 300…
A:
Q: n XYZ primary School, as soon as the payment of the invoice is received from a family, it needs to…
A: BPMN Diagram below. You can recreate your own basing this diagram if you want.
Q: Employee view attendance report The employee must be logged in to the system to perform this…
A: One Actor? Answer: Employee One Use Case Name? Answer: A use case describes a function that a…
Q: A travel company provides a selection of Hotels that prospective customers can reserve prior to…
A: Draw an Entity-Relationship data model for the above scenario neatly
Q: ntment you have to 1 Add a new patient 2 Display patients that have an appointment 3 Display all…
A: Hospital Management System Create a structure containing patient information like patient id, name…
Q: Indicate the decimal number corresponding to the permission
A: The correct answer is: The instructor should use: chmod 644 to set the access permission for the…
Q: The list of projects that each employee worked on. The average award received by each employee. The…
A: Given: The given code is used to perform tasks by reading a CSV(comma separated values) file from…
Q: AuctionBase In this project, we are developing an online e-commerce website (similar to eBay). You…
A: EERD is given below for given question
Q: school has 100 lockers and 100 students. All lockers areclosed on the first day of school. As the…
A: Create a class Program. Declare an integer variable, size, and initialize it to 100. static…
Q: 17 Business and employment services category is one of the e-government service preferences, which…
A: Required: 17 Business and employment services category is one of the e-government service…
Q: Challenge Day The Day of Challenge is one of the favorite social sport events of people since 1991.…
A: Code: #include <iostream>using namespace std;int main() { int n; cin>>n; long…
Q: Nomenclature is a system for giving names to things within a particular profession or field. The XYZ…
A: A regular expression is a sequence of characters that define a search pattern, mainly for use in…
Q: Product List Web Application Using React Hooks Create a Product List application using React Hooks.…
A: STEP 1. Create a Chec account and upload Product Info STEP 2. yarn install or npm…
Q: The following is a sample report from a child clinic. It shows the days and treatments for visits to…
A: Answer :
Q: nstruction: Identify if the following is UNIQUE IDENTIFIER or NOT. Plan ID Workout ID
A: Answer: I have given answered in the brief explanation
Q: AdminID CourselD CourseName AdminPassword CourseFees AdminName have Admin Course AdminDetails…
A: SQL Queries First, we have to create tables. Create database first then create tables Use create…
Q: Salesforce POC Task: You are working on the live project of a foreign client and the client wants…
A: Brief About the Question: The question is based on the Creation of custom field in SObject But apart…
Q: javascript data security exercise. Inside of a closure, create an object called pii (Personally…
A: index.html <!DOCTYPE html><html lang="en"><head> <meta charset="UTF-8">…
Q: Alternative Assignment 2 Task: Create a protected user account database.using PHP and SQL…
A: Create a database called registration. In the registration database, add a table called users:…
Q: Q) A user receives a ph call from a person who claims to represent IT
A: Explanation Social engineering is a sort of attack that relies heavily on human interaction and…
Q: VVVVIP 30 Min please Answer both parts a and b You are appointed as a software developer to develop…
A: AIRPORT class Have to classes Custom officer and passenger
Q: I have just started learning Salesforce. I don't know how to create a Validation Rule Can you please…
A: Validation Rule: - A validation rule is used to validate specific criteria or formulas on the basis…
Q: explaain these href attributes thanks rel="nofollow" rel="dofollow" Rel="Follow"
A: A no follow link is one that does not count as a point in favor of the page, does not improve…
Q: ecase diagram of the Habit tracker. A habit tracker is designed fo aviors. The application allows…
A: Q
Q: This will be a 3-part script project. Follow the guidelines below: First script will be named as…
A: circle.py: Raw_code: #circle classclass Circle: #initializer def __init__(self, radius):…
Tairiq Mines
Error! Bookmark not defined.Tairiq Mines in Glen Austin has several parking lots, which are used by
staff. Each parking lot has a unique name, location, capacity, and number of floors (where appropriate).
Each parking lot has parking spaces, which are uniquely identified using a space number. Members of
staff can request the sole use of a single parking space. Each member of staff has a unique number,
name, telephone extension number, and vehicle license number.
Source: Connolly, T & Begg, C (2015), A Practical Approach to Design, Implementation and Management, Pearson
Question 5
5.1 Represent the above as a single Entity Relation model. Provide any assumptions necessary
to support your model
5.2 Write an SQL query that displays the parking space number, location as well as the name
of the staff member to whom the parking space has been allocated.
Step by step
Solved in 3 steps with 1 images
- In an annual charter day celebration of a university, one of the highlights of its celebration is having a concert for a cause in which national personalities were invited. The student body assigned for the conduct of the event, sold tickets for their fund raising for a cause. Tickets are sold according to the following prices. The green ticket is sold at $20, orange ticket at $30 and white ticket at $40. All students of the university are encouraged to support the said event, however the venue could only accommodate 1500 people. Write a Nassi-Shneiderman diagram that determines the total amount of money that will be generated if all tickets are all sold out and likewise print the total money collected.II. Application Q1. Given below is an example of e-commerce website. Analyze any one e-commerce website and write various test cases for it. Write any two test cases based on it and give at least three activities of each type of cases.Project: Covid-19 Vaccination Appointment Group members: 1 You need to follow the MVC architectural pattern to develop an online Covid-19 vaccination appointment system using Java Servlets and JSPs. Requirements: The user shall enter his National ID number (then submit the request) The system shall determine if the user: Fully vaccinated – boosted (a person who received two doses, and a booster shot). Fully vaccinated (Two doses) ? (can go for a third shot (vaccine booster shot), see Req 6 below). Already received the first dose ? Allow the user to book an appointment for the second dose Didn’t take any dose ? Allow the user to book an appointment for the first dose The user shall be able to determine the vaccination type (for the first dose only) The user shall be able to select the date/time for the appointment If the user is booking an appointment for the second dose, the time between the first and second dose shall not be less than N weeks (N is configurable in the database based…
- 1.1 tblMembers The tblMembers will be used to store the details of the Gym Members MemberID, Name, Surname, DateOfBirth, ID,Contact, DateJoined MemberType (Annual: R200/year, Monthly: R50/month)1.2 The tblPayments table will be used to keep track of payments made by Members. PaymentID, Date, Amount. The tblPayments should be related to tblMembers accordinglyUsing Java and the jdbc API , create a startup frame that will be used navigate the application. The frame should have 3 buttons.1.3 The first button will open aa frame that can be used to add, update and delete Gyjm Members. 1.4 The second button will open a frame that will be used to collect the payments made by students.1.5 The third button will display a frame that calculates the current age and the balances, and displays a summary report in a table, as follows for an example:Order # is the sequence number of the member in tblMembers table. Should a member be deleted the system should adjust the sequence as well.- Age is the…Granite Sales Company keeps information on employees and the departments that they work in. For each department, the department name, internal mailbox number, and office phone extension are kept. A department can have many assigned employees, and each employee is assigned to only one department. Employees can be salaried employees, hourly employees, or contract employees. All employees are assigned an employee number. This is kept along with the employee’s name and address. For hourly employees, hourly wage and target weekly work hours are stored (e.g. the company may target 40 hours/week for some, 32 hours/week for others, and 20 hours/week for others). Some salaried employees are salespeople that can earn a commission in addition to their base salary. For all salaried employees, the yearly salary amount is recorded in the system. For salespeople, their commission percentage on sales and commission percentage on profit are stored in the system. For example, John is a…Acknowledge any single capital letter letters in order and a positive whole number between 1 to 10 from the client. Create the three-sided design out of it. The quantity of columns in the example ought to be equivalent to the number acknowledged from the client. Add suitable approvals, for example, the person is letters in order and capital letter. Likewise approve in the event that the number is a positive number between 1 to 10. For example Assuming that character entered is 'G', then result ought to be as per the following: G G G G G GG G G Greply?
- Student Companion ™ is your personal academic guide that provides the following basic information for each course while a student at the USC. Courses done, grades earned, Course outline attachments, course notes etc.This is a simple application to keep track of each course you are doing/have done and can serve as a personal test timetable for the course which has final quiz, keep track of your courses that have etc. The concept is like a personal check sheet system blended with a simple quiz timetable. This also solves a problem that often shows up when students have completed their program and need to revert back to data pertaining to their academic life from their viewpoint. Please note this does not replace a transcript, which is an official University Document. 1. Create a Class Diagram of at least six (6) major entities for your application. For entities with a large number of attributes you are allowed to limit your attributes to a max of six (6). All operations within each class…P1 - Loan Payment Schedule Main Street Bank is offering an annual interest rate discount based on the client’s credit score. The discount for each credit score level is provided in the table below. The lowest credit score is 300 while the highest credit score is 850. For example, the new interest rate for a client with a credit score of 755 and a current interest rate of 4.25% would be 4.25 – 0.75 = 3.50% interest rate Credit Score Rating Interest Rate Discount 300 - 579 Very Poor 0.00 580 – 669 Fair 0.25 670 - 739 Good 0.50 740 - 799 Very Good 0.75 800 - 850 Exceptional 1.00 Use modular programming concepts Create a program that includes a WHILE loop to generate a payment schedule for loans that are paid in equal monthly payments Input the loan number and retrieve required loan account from MS_LOANS table Output is shown below Monthly interest is calculated by dividing the yearly interest rate by 12 to get a monthly interest…Draw the domain class diagrams Scenario: Lillian’s Auto Works Lillian is the owner of Lillian’s Auto Works, a vehicle servicing center based in Gqeberha. Lillianrequires a new computerized Vehicle Servicing Record System (VSRS) - with a websitecomponent for private customers - to keep track of all customers and their vehicle’ serviceinformation. Lillian’s Auto Works’ customers can be private customers or companies.For private customers their id number must be submitted, whereas for companies their VATnumber is recorded. Each customer is allocated a unique customer number, and has a name,address and telephone number. Each customer can own many cars. The registration numberof the car uniquely identifies it, and the make, model and model year of the car must berecorded. A car is owned by only one customer. Customers bring their cars in for a service.A car can be brought in many times to be serviced.The system must keep information about Lillian’s employees. Details include employeenumber,…
- Open your text editor and create a new document named model.php model.php will contain functions that will connect to a database potentially return PDO statementobjects to the controller for processing. updateMessagesfunction updateMessages($id)This method will take a single parameter of id which is the saved id from the last or latest message displayed. It will conditionally select from the table “messages”, id, name, message, and time. The condition is that the field id is greater than the parameter for id. The return is the PDOStatement object with the row data from the query.Q: Make a use-case diagram, write use-case description (fully dressed) of any 3 use-cases - selected use- cases shouldn't be basic like register, login, logout etc, make GUI of selected use-cases, using following scenario: A client wishes to develop a COVID-19 Tracer App. The app should automatically track and store contacts’ IDs of two users with same app. The users should be able to see a login/signup window upon new installation of app. The user must be able to view his/her account information. The user can update his/her account information. The user can view the ID numbers of contacts he/she made in recent 15 days. The user must be notified if someone tested COVID positive among his/her contact. The user can view COVID symptoms. The user should be able to check his health condition in terms of COVID symptoms. The user can view self quarantine guidelines. The user should be able to view COVID statistics in his/her area. The user can view COVID statistics around the whole country.…Job portal system: This system allows the students to search and apply for jobs etc. online. The manager can use the system for posting and deleting job offers etc. Create your own case study (problem statement) for the above application and Draw the use case diagram Class diagram with at least 4 classes and explain all the relationships Draw a DFD-0 for this application