Overview

The purpose of this assignment is to give you experience designing a database and building an Entity Relationship Diagram in a business scenario. Submit all tasks in one document. Include headings in your document.

The organization is a dentist's office. When new patients are seen for the first time, they complete a patient information form that asks for their name, address, phone number, and brief medical history, which are stored in the patient information file. When a patient calls to schedule a new appointment or change an existing appointment, the receptionist checks the appointment file for an available time. Once a good time is found for the patient, the appointment is scheduled. If the patient is a new patient, an incomplete entry is made in the patient file; the full information will be collected when the patient arrives for the appointment. Because appointments are often made far in advance, the receptionist usually mails a reminder postcard to each patient 2 weeks before the appointment.

Consider the information needed for the patient billing system:

• Patient information - The system should be able to retrieve their contact information as well as their age, blood type, occupation, employer information, and insurance carrier information.

• Insurance carrier information -The system should be able to retrieve the number of patients on plan and the carrier's contact information.

• Dentist information - The system should be able to retrieve information about the dentist.

Instructions

After completing the learning activities for this module, use what you have learned to complete this assignment:

1. Create a Class diagram. Draw a conceptual class diagram with a minimum of 7 classes.

2. Create an Entity Relationship Diagram (ERD). Include a minimum of 7 entities and 50 attributes.

3. Create a CRUD Matrix.

Write a Python code that will ask a user to input a year and return "Leap Year" if the year is a leap year, or "No Leap Year" if it is not a leap year. The program then asks for another year and performs the same task in the form of a loop, until the user inputs the then integer "-1." At that point, the program will exit the loop.

Program to implement in c++

dont forget to implement the 2D array and print whether the vehicle is available or not! This is the main part that I dont know how to implement! no good rating if this isnt done.

Define a class Vehicle that has the following data members:  Model of the vehicle (e.g., Ford, Toyota) as a standard library string.  The date that vehicle has joined to the fleet use the class Date that has the following data members:month, day, year. The mileage of the vehicle as an integer.  A four digit id of the vehicle as a standard library string, such as string vehicle_id = "2345";  A two-dimensional 12-by-30 array of Boolean variables that shows whether the vehicle is available or has been rented out for each day of the year. If the vehicle is available on a given date then Boolean variable is true and if rented out is false. Each row of the array corresponds to a month and for simplicity we assume that the number of days in each month is 30.

Using Windows Functions

a) Write a query that will produce the table above as an outcome

b) Why are all the values equal in the last tuple of the table

c) Write a second query that will add a column to the table that will also provide the max amount of hospitalization for all providers.

Answer the following questions and provide a brief explanation:

1. How many values does it take to represent a joint distribution p(x, y) of 4 boolean variables?
2. How many of these values can be chosen independently?
3. What are the answers for the above question if we know that x and y are independent?

You has been requested to design and develop a food ordering system based on following requirements:

The system shall allow the user to place an order for the food(s), view the food details, modify or delete the details of the food if necessary. Your program should be menu driven, giving the user various choices. You shall design the system by demonstrating the full understanding of object-oriented and use of list/link-list concept.

For every food order, the following information will be stored: Order ID (Auto assigned, unique ID), Food Code, flavor (example: Strawberry, chocolate), weight (Kg), Unit Price, Qty and customer information who order this cake. The customer information consists of customer ID, name, address and contact number. The order ID shall be automatically assigned with a unique ID when new order is added. The system shall display additional information that is amount (unit price * qty) when viewing the order details.

*in C++ language .

Root is a trie that has characters for values. When traversed it spells words by formin strings.

I'm trying to make findNode such that it will return the node at which we start collecting candidates for words that start with a specific prefix.

How do I code this method traversing depth-first?

my code:

private static TreeNode<Character> findNode(TreeNode<Character> root, String prefix, int index){

Stack <TreeNode<Character>> s = new Stack<>();

s.push(root);

for(TreeNode<Character> child : root.getChildren()){
while(index <= prefix.length()-1){
if(prefix.charAt(index) == child.getValue()){
index++;
findNode(child, prefix, index);
if(prefix.charAt(index) != child.getValue()){
return child;  
}
}
}
}

}

Problem 3.

Let G be the grammar we saw in homework 3:

E -> E + T | E - T | T

T -> T * F | F

F -> ( E ) | x | y

Let w be (x + y) * x - y

a) Show the leftmost derivation for w in G. Number the rules for G and show the corresponding rule number under each substitution arrow in the derivation.

Hint: it may be easier to create a parse tree first, as you did in homework 3

b) Convert G to a string-pushing PDA, call it D_G; show a transition diagram for D_G. There will be one reduce transition for each terminal symbol in G and one shift transition for each rule in G.

Label all transitions in D_G as follows:

• T_i and T_f for the initial and final transitions

• R_c for a reduce transition that reads terminal symbol c

• S_k for a shift transition that corresponds to rule numbered k in G

c) Show an accepting computation for w in D_G as a table. This table will one row per transition, and 4 columns: remaining input, current state, stack contents, and next transition. For example, the first row in your table will be (w, q₀, e, T_i)

Hint: use your derivation from part (a) to help you choose the shift transitions

Would anyone know how to code this in SQL? I can't quite figure it out.

The following drop command is inserted for convenience so that if you need to recompile your code, it will drop the table

DROP TABLE Orders Cascade constraints

DROP TABLE OrderLine CASCADE CONSTRAINTS;

-- CREATE TABLE Orders

(

ordernum INTEGER PRIMARY KEY,

priority CHAR(10) NOT NULL,

cost INTEGER NOT NULL, /*

IC1: The priority is one of: high, medium, or low */

>>

/* IC2: The cost of a high priority order is above 2000. */

>>

/* IC3: The cost of a medium priority order is between 800 and 2200 (inclusive). */

>>

/* IC4: The cost of a low priority order is less than 1000. */

>>

Thank you in advance!

II.                Answer the following questions accordingly:

1. What is meant by the concept of management myths.

2. Explain the incremental model with respect to its features, advantages and disadvantages.

3.   Discuss the term engineering with respect to the term generic process framework.)

4.   List and explain any three (3) umbrella activity under the software framework.

1. In real-world data, tuples with missing values for some attributes are a common occurrence. Describe various methods for handling this problem.

1. What is meant by the concept of management myths.

2. Explain the incremental model with respect to its features, advantages and disadvantages.

3.   Discuss the term engineering with respect to the term generic process framework.

4.   List and explain any three (3) umbrella activity under the software framework.

1.   Assume that you are a software engineer. A client is asking you to develop a mobile application to manage the data in his mobile, with an advanced feature such as accepting voice as an input. However he still needs your help to identify other possible features. What is the most suitable process model?

2.   Mr. X wants an integrated Information System for his Car Company. He knows that the scope of the system is huge but wants it as soon as possible. He is willing to pay for the software for as long as all the subsystems are complete and delivered on time. If you are the software engineer, what process model will you use?

C++ EXERCISES

(a) Given int a = 5, b = 2, c = 4, and d = 5; determine the value of the expression:

d % b * c > 5 || c % b * d < 7.   

(b) Which repetition statement is preferred for user data input and its validation?             

(c) Write a for statement to populate an array, double val[NUMCOUNT], for the following case: Use a counter named double count that has an initial value of 16.2, a final value of 0.4, and a decrement of 0.2 and populate the val[] array with the value of count.

What is the size, NUMCOUNT, of the array val[]?

Write an if statement that uses the turtle graphics library to determine whether the turtle’s pen color is red or blue. If so, set the pen size to 5 pixels.

Python.