What do you think of the materials used in Smartphones?

You must write one paragraph, with a topic sentence and supporting ideas, and citations and an APA reference list.

Short-run cost function tables presented in chapter five include information detailing average variable cost, average fixed cost, average total cost, and marginal cost. Which of the figures do you consider most important for an organization to evaluate when determining levels of production? Why do you believe that factor is the most important?

no less than 250 words in length, make at least one reference to your text or other course materials and provide in-text citations. As you reference information from a source, be sure to provide APA citations in text and at the end of your post.

Explain what is meant by cardinalities in database.

Why is atomicity in database design important?

I think that SQL language is a great tool for database creation and manipulation. The basics of SQL are easy to learn and understand. The coding is simple from the creation, changing, or even deleting data from the database. I overall really like learning SQL I can easily visualize what I am doing with the code.

What could be added to this post?

Assume that you have a Saudi league player database. In this database, you have a table containing players’ attributes such as (Name, age, position, etc.) and you decided to add information about players’ agents. Would you represent the agent information as attributes in the player table or would you create an entity set for players’ agents? Justify your answer.

For the given database schema. Answer the following questions.

Company Database customer(cust_id, name, address)

product(product_id, product_name, price, quantity)

transaction(trans_id, cust_id, time_date)

product_trans(product_id, trans_id)

Identify the primary keys and foreign keys for the relations and specify at least two different types of integrity constraints that would be applicable for different relations given.

.So I have a project, I just want a general answer on how would you start it. I have to make the Backend read/write from the database. What does that mean and how you u do that general example, please. in php please

EX - would i just make a script that just connects to the database , or is it more to it

Database Application Development

Project/Assignment

Milestone 1 (part 1)

Objective:

In this assignment, you create a simple HR application using the C++ programming language and Oracle server. This assignment helps students learn a basic understanding of application development using C++ programming and an Oracle database

Submission:

This Milestone is a new project that simply uses what was learned in the SETUP.

Your submission will be a single text-based .cpp file including your C++ program for the Database Application project/assignment. The file must include a comment header of student name and ID number.

AS_Part1.txt

Your submission needs to be FULLY commented.

Note: you can submit combine code of part1 and part2 as final.txt also

Instruction:

In this assignment, we use the same database that you use for your labs.

Connecting to an Oracle database from a C++ Program

In your function main(), create a connection to your database.

You need to implement the following functions:

int menu(void);

The menu() function returns an integer value which is the selected option by the user from the menu. This function displays the following menu options:

1. Find Employee
2. Employees Report
3. Add Employee
4. Update Employee
5. Remove Employee
6. Exit
7. Before printing the menu, display the following title on the screen

********************* HR Menu *********************

Prompt the user to enter an option. If the user enters an incorrect option, the user is asked to enter an option again. When the user enters a correct option (1 to 5), the function returns the selected value.

If the user selects 6 (Exit), the program terminates.

int findEmployee(*conn, int employeeNumber, struct Employee *emp);

This function receives a connection object, an integer number as the employee number, and a pointer to a variable of type Employee. The function returns 0 if the employee does not exist. It returns 1 if the employee exits.

To store the employee data from the findEmployee() function, we use a variable of type structure called Employee. The Employee structure has the following members:

struct Employee{

int employeeNumber;

char lastName[50];

char firstName[50];

char email[100];

char phone[50];

char extension[10];

char reportsTo[100];

char jobTitle[50];

char city[50];

};

The ReportsTo member stores the first name and the last name of the employee who is the manager of the given employee number.

If the employee exists, store the employee data into the members of an Employee variable using the third parameter in the findEmployee() function which references to that variable of type Employee.

Note: For this report, you may need to query more than one table (join).

void displayEmployee(*conn, struct Employee emp);

If the user selects option 1, this function is called. First, prompt the user to enter a value for the employee number. Then, call function findEmployee() to check if the employee with the given employee number exists. If the returning value of function findEmployee() is 0, display a proper error message.

Sample error message:

Employee 1122 does not exist.

Otherwise, call the function displayEmployee() to display the employee information.

This function receives a connection pointer and values of a variable of type Employee and displays all members of the emp parameter.

Display the employee information as follows:

employeeNumber = 1002

lastName = Murphy

firstName = Diane

email = [email protected]

phone = +1 650 219 4782

extension = x5800

reportsTo =

jobTitle = President

city = San Francisco

void displayAllEmployees(*conn);

If the user selects option 2 (Employees Report), call function displayAllEmployees().

This function receives a connection pointer and displays all employees’ information if exists.

Write a query to select and display the following attributes for all employees.

E                 Employee Name          Email                                                                   Phone                           Ext              Manager
------------------------------------------------------------------------------------------------------------------------

1002          Diane Murphy                                 [email protected]                    +1 650 219 4782                   x5800        

1056          Mary Patterson                               [email protected]                  +1 650 219 4782                   x4611         Diane Murphy

1076          Jeff Firrelli                                        [email protected]                                      +1 650 219 4782         x9273         Diane Murphy

Note: For this report, you may need to query more than one table (join).

If the query does not return any rows, display a proper message:

There is no employees’ information to be displayed.

Note: For each query in your assignment, make sure you handle the errors and display the proper message including the error_code.

Error_code is a number returned if the query execution is not successful.