Using the INTERRNA database (mfrlab.org/interrna/); how many T-loop base motifs (patterns) can be found in the structure of the ribosomal RNA subunit with the PDB code 1ffk? *

6

1233

8

33

14

Database:

Question 11

Using the ERD from problem 10, create the relational schema.(Create an appropriate collection of attributes for each of the entities. Make sure you use the appropriate naming conventions to name the attributes.)

The realtime results are available on the server in a database. What would the effects of browser and server caching, and I'll be using AJAX, and how would I estimate the load this will put on the site in terms of hit rate and bandwidth consumption.

PLEASE USE ASSEMBLY LANGUAGE

The database students.db contains student records. Each record contains a name (30B ASCII), student ID (9B ASCII), 3 grades out of 100 (3B integers), and a letter grade (1B ASCII).

For the file students.db described above, assume all records are ordered alphabetically based on the name field. A record for a new student has been entered and stored in memory. Determine how to insert the new record into the database (Hint: use string compares to determine where it goes, the create a temp file, copy record that should come before it into the temp, then copy new record, then all other record into temp file. The delete the original and rename the temp file to students.db.

Examine the following case from Turner, Weickgenannt, and Copeland (2017):

Arminello, Inc. does not use a database system; rather, it maintains separate data files in each of its departments. When a sale occurs, the transaction is recorded in the sales department. Next, documentation is forwarded from the sales department to the accounting department so that the transaction can be recorded there. Finally, the customer service group is notified so that its records can be updated. (p. 499)

Describe the data redundancy and concurrency issues that are likely to arise under this scenario at Arminello, Inc. Then determine the requirements for the database system and recommend a solution to achieve the desired results. The recommendation must reflect best practices for timeliness and completeness of the information, the controls that need to be in place, and the best platform for the system.

Create short flowcharts for each of the following examples:

1. Data gathered from magnetic disk is displayed on a computer screen and printed out on a report

2. Manually updating the sales journal using the sales invoices

3. Using the employee pay detail report to manually prepare employee payroll checks. The completed payroll checks are then sent to the employees

4. Data from a source document is manually copied into a ledger then stamped to indicate is has been processed. Afterwards, the stamped document is filed in alphabetical order.

5. Customer sales orders are received into the system and processed electronically, then the sales order data is saved to a database. The sales order data is then pulled from the database and used to prepare three copies of the monthly sales report.

Consider the automobile insurance company database we use for examples in class. For each problem, write an SQL statement to retrieve the specified data.

1. For each accident that occurred in 2005, the names of drivers involved and the make and year of the auto they were driving.
2. The name and ssn of automobile owners who have never been the driver in any accident.
3. The name and ssn of people involved in accidents while driving a car they do not own. (Remember that cars may have multiple owners.)

Database Schema:
• People (ssn, fname, lname, city, state)

• Agents (ssn, salary, photo)

• Autos (vin, make, year, agent_ssn)

• Owns (ssn, vin)

• Accidents (aid, accident_date, city, state)

• Involvements(aid, vin, damages, driver_ssn)

Note: The advertising, telephone, and electricity expenses are debited to miscellaneous expense since there are no separate expense accounts provided for the same.

Prepare an income statement, a retained earnings statement, and a balance sheet.

If an answer is zero, enter "0".

9. Journalize the closing entries on Page 4 of the journal. (Do not insert the account numbers in the journal at this time.) Post the closing entries to the general ledger in the spreadsheet. Then go back and enter the appropriate posting references in the journal. (Income Summary is account #34 in the chart of accounts.)

For a compound transaction, if an amount box does not require an entry, leave it blank.

10. Prepare a post-closing trial balance. List the accounts in order by type: Assets, Liablities, Capital, Dividends, Revenue, and Expenses. If an amount box does not require an entry, leave it blank.

Janet, after years of working as a hairdresser and as a makeup artist, decided to go into business for herself. Over time the business has grown into a spa and beauty retreat and she now employs a few staff. With her growing operation she has identified the need to implement a computerized accounting information system. In order to have a system that meets her needs exactly and also to save cost, she has asked you to create a simple, customized solution for her business. Her immediate need is for a customer sales information system, so that is what you will now create. With customer service being so important to Janet, her customers tend to become regulars and she wants to maintain a record of each customer’s contact information and preferences so that the spa will know what is important to the customer without having to be told each visit. The customer information that Janet considers important to maintain is the full name, cellphone number, favourite treatment, and special considerations (e.g. some customers have allergies or require fragrance-free products). For employees, Janet just needs to record the names and cell phone numbers in the database. The spa also has a standard list of services which each have a standard name, description and price. Janet also wants a database record of each customer visit both for customer billing at the time of service, as well as for future analysis. Janet wants to refer to these sales transactions as “Visits” in the database in order to reflect the spa’s focus on customers’ experiences. For each of these customer visits it is important to record a unique visit identifier, the date, the customer, the main staff member who served the customer, and the service or services experienced (sold)

Based on Janet’s requirements, list out the entities and relationships that should be present in the database, indicating the cardinality of each relationship.