1. Analogous structures perform similar functions but do not arise from common ancestry. What explains the existence of analogous structures? Name 3 differences between the skull features of chimpanzees and humans. What era of geologic time are we in currently?
2. Name two types of organisms that belong to each of the phyla: Annelida, Mollusca, and Echinodermata. Name an adaptation of a crayfish and one adaptation of a grasshopper that benefit their survival in their respective environments. Describe the types of skeletons that arthropods and vertebrates have。

An older naming system uses Latin names of the elements. For example, the Latin name of iron is ferrum (which gives iron its symbol of Fe). For metals that can have more than one charge, the Latin name takes a –ous ending for the smaller charge and an –ic ending for the larger charge. Based on these rules, what is the Latin name of Fe22​O33​?

A Ferrous oxide

B Ferric oxide

C Ferrum oxide

D Iron oxide

Write out code for a nested if statement that allows a user to enter in a product name, store the product into a variable called product name and checks to see if that product exists in your nested if statement. You must include 5 product names to search for. If it is then assign the price of the item to a variable called amount and then print the product name and the cost of the product to the console. If it does not find any of the items in the nested if statement, then print that item cannot be found. (using Python Only)

C++ Language

Problem 2 (Save and Get Info) : Write a program that asks for the user's name, phone number, and address. The program then saves all information in a data file (each information in one line) named list.txt. Finally, the program reads the information from the file and displays it on the screen  in the following format:

Name: User's Name  
Phone Number: User's Phone Number  
Address: User's Street Address
User's City, State, and Zip Code

In python please write the following code the problem. Write a function called play_round that simulates two people drawing cards and comparing their values. High card wins. In the case of a tie, draw more cards. Repeat until someone wins the round. The function has two parameters: the name of player 1 and the name of player 2. It returns a string with format '<winning player name> wins!'. For instance, if the winning player is named Rocket, return 'Rocket wins!'.

C++

Write a program that declares two variables:a string firstName and int age.Write a function, called getName, that when called, prompts the user for their first name.

The function should return the first name and store it in the firstName variable.

Write a function, called getAge, that when called, prompts the user for their age.

The function should return the age and store it in the age variable.

Write a function, that uses the firstName and age as arguments.In the function, print out the person’s name and age.

Linux

Create a simple 'user' file -user name, user id, some few other fields (at your discretion). Name it 'users'. Enter about 10 entries there.

Create a simple 'user_data' file -user name, phone, address etc at your discretion.. User names in both files should match. So there would be 10 users in both files. You probably want to do these files as tab -separated, rather than space separated.

1. Write a SQL statement which joins the rider_student table with the rider_major table and lists the rider student name and the name of the major (major_name) and the description of the major for which they are currently assigned. (You may use the SQL 'join' subclause, or simply express the join as part of the 'where' clause by indicating that you only want records where the primary key of the child table, rider_major, equals the corresponding foreign key of the joined table, rider_student.)

2. Write a SQL statement which joins the rider_student table with the rider_major table and lists the rider student name and the name of the major (major_name) and the description of the major for which they are currently assigned. The SQL statement should only select records for students who are majoring in Information Systems.

3. Write a SQL statement which joins the rider_student table with the rider_major table and lists the rider student name and the name of the major (major_name) and the description of the major for which they are currently assigned. The SQL statement should only select records for majors who are graduate students (graduate_only = 'TRUE’).

4. Write a SQL statement which joins the rider_student table with the rider_major table and lists the rider student name (select CONCAT(first_name,' ',last_name) AS NAME) and the name of the major (major_name) and the description of the major for which they are currently assigned. The SQL statement should only select records for majors who are graduate students (graduate_only = 'TRUE’)

5. Write a SQL statement which joins the parts table with the supplier table and lists the part_name, supplier_name for all parts in the part table. The supplier_id column in the suppliers table is the primary key in the suppliers table, and this key has been exported to the parts table where it is a foreign key. You should use an inner join for this query.

6. Write a SQL statement which joins the parts table with the suppliers table and lists the part_name, supplier_name. You should return all rows from the parts table whether or not there are corresponding rows in the supplier table. You should use an outer join for this query.

7. Write a SQL statement which joins the parts table with the supplier table and lists the part_no, part_name, supplier_name from parts and suppliers table. Only return the parts supplied by ‘Fred Smith ..'. You should use an inner join for this query.

8. The faculty table contains faculty information and has a faculty_id as the primary key. The faculty_department table has the department assignments for faculty members and has the faculty_id from the faculty table as an exported key or foreign key. The department table has information about departments and has a department_id column as its primary key. The faculty_department table also has the exported key or foreign key for the department table.

Write a SQL statement to display faculty_id, first name, last name, department_id, department name (need to joins the faculty table with the faculty_department table with the department table. )Use an inner join for this query.

Overview

For this assignment, implement and use the methods for a class called Seller that represents information about a salesperson.

The Seller class

Use the following class definition:

class Seller
{
public:
  Seller();
  Seller( const char [], const char[], const char [], double );
    
  void print();

  void setFirstName( const char [] );
  void setLastName( const char [] );
  void setID( const char [] );
  void setSalesTotal( double );

  double getSalesTotal();

private:
  char firstName[20];
  char lastName[30];
  char ID[7];
  double salesTotal;
};

Data Members

The data members for the class are:

• firstName holds the Seller's first name

• lastName holds the Seller's last name

• ID holds the Seller's id number

• salesTotal holds the Seller's sales total

Constructors

This class has two constructors. The default constructor (the one that takes no arguments) should initialize the first and last names to "None", the seller ID to "ZZZ999", and the sales total to 0.

The other constructor for the class should initialize the data members using the passed in arguments. It takes 4 arguments: a character array with a Seller's first name, a character array with a Seller's last name, a character array with a Seller's id number, and a double that holds the Seller's sales total. The data members should be initialized by calling the various set methods.

Methods

void print()

This method displays the Seller information. It takes no arguments and returns nothing.

The information should be displayed as follows:

Giant, Andre               BIG357               678.53

void setFirstName( const char [] )

This method changes a Seller's first name. It takes one argument: an array of characters that represents the Seller's first name. It returns nothing.

If the length of the passed in argument is greater than 0, it should be used to initialize the firstName data member. Otherwise, the firstName data member should be set to "None".

void setLastName( const char [] )

This method changes a Seller's last name. It takes one argument: an array of characters that represents the Seller's last name. It returns nothing.

If the length of the passed in argument is greater than 0, it should be used to initialize the lastName data member. Otherwise, the lastName data member should be set to "None".

void setID( const char [] )

This method changes a Seller's id number. It takes one argument: an array of characters that represents the Seller's id number. It returns nothing.

If the length of the passed in argument is greater than 0 and less than 7, it should be used to initialize the ID data member. Otherwise, the ID data member should be set to "ZZZ999".

void setSalesTotal( double )

This method changes a Seller's sales total. It takes one argument: a double that represents the Seller's sales total. It returns nothing.

If the passed in argument is greater than or equal to 0, it should be used to initialize the salesTotal data member. Otherwise, the salesTotal data member should be set to 0.

double getSalesTotal()

This method returns a Seller's sales total data member. It takes no arguments.

main()

In main(), create 5 Seller objects. They should contain the values:

• The first Seller should have your name, an id of "CSI240", and a sales total of 1234.56. Note: if you're pair programming, set the first name to the first name of both you and your partner: "Jane/John" and the last name to the last name of both you and your partner: "Doe/Doe".

• The second Seller should be created using the default constructor (the one that doesn't take any arguments)

• The third Seller should have the first name of an empty string (""), a last name of "Robinson", an id of "TOOBIG999", and a sales total of -876.34.

• The fourth Seller should have the name "Tarik Cohen", an id of "RUN29", and a sales total of 13579.11

• The fifth Seller should have the name "Kyle Long", an id of "TACK75", and a sales total of 24680.24

The rest of main() will include using the various methods on each of the 5 Seller objects. Display a label similar to "The first Seller" before anything is outputted for each of the objects.

For the first Seller, display the Seller information.

For the second Seller, display the Seller information, set the Seller name to "Mitchell Trubisky", set the id number to "QB10", set the sales total to 246.80, and then display the Seller information once again.

For the third Seller, display the Seller's information, set the Seller's first name to "Allen", set the id number to "WIDE12", set the sales total to 9900000.99, and then display the Seller information once again.

For the fourth Seller, display only the Seller's sales total.

For the fifth Seller, display the Seller's information, set the first name to an empty string (""), set the last name to an empty string, set the id number to an empty string, set the sales total to -52.96, and then display the Seller information once again.

Programming Notes

1. Each method must have a documentation box like a function.

2. Hand in a copy of the source code using Blackboard.

Output

Note: The information for the first Seller object will have your name.

The First Seller
Da Bear, Staley                 CSI240        1234.56

The Second Seller
None, None                      ZZZ999           0.00
Trubisky, Mitchell                QB10         246.80

The Third Seller
Robinson, None                  ZZZ999           0.00
Robinson, Allen                 WIDE12     9900000.99

The Fourth Seller
The sales total is $13579.11

The Fifth Seller
Long, Kyle                      TACK75       24680.24
None, None                      ZZZ999           0.00