What would be some good user requirements (At least 10) for a furniture store database? An example would be:

For employees:

- Must have access to the order history of a customer.

- Needs to be able to find out the most popular product.

Design a report useful to management and describe how to obtain it from the accounting system. Detail the entities and attributes needed, the database relationships needed to obtain those attributes, any other report criteria, and the purpose or use of the report

During this learning plan, you completed an research on your competitors in general through Hoovers database in the NAU Online Library. Based on the results of your competitor search, give a recap of your Competitor Profile for your business.

Which of the following database models requires knowledge of the hardware being used?

Question 40 options:

• What is an n-tier architecture? Why do we need to use n-tier architecture?
• What is a service-oriented architecture? Provide an example of a service-oriented architecture.
• Discuss the different architectural models for Database as a Service

We produce picture frames for stores such as Michael’s and Hobby Lobby. In the assembly department, the wooden slats are added at the beginning of the process, and the glass is added when the process is 25% complete. Conversion costs are added evenly throughout the period. Here is the data related to the assembly department for November 2018:

WIP, November 1 (40% complete) 60 frames

Started in November 500 frames

WIP, November 30 (15% complete) 100 frames

Costs included in the Beginning WIP:

DM - wooden slats $ 300

DM - glass $ 180

CC $ 168

Costs added during November:

DM - wooden slats $ 2,950

DM - glass $ 1,500

CC $ 3,580

Note: When calculating equivalent units (Step 2), total costs (Step 3), and cost per equivalent unit (Step 4), you will have 3 columns - DM slats, DM glass, and CC. Therefore, when you assign costs in Step 5, you’ll assign all 3 costs for each layer.

Using Weighted Average:

a. Prepare T-accounts for WIP in units and in $ to represent this situation.

b. Prepare the 5-step Production Cost Report.

c. Update the T-accounts to reflect the amounts transferred out and the amounts in Ending WIP.

At December 31, 2017, Novak Corporation reported the following plant assets. Land $ 3,198,000 Buildings $26,610,000 Less: Accumulated depreciation—buildings 12,712,050 13,897,950 Equipment 42,640,000 Less: Accumulated depreciation—equipment 5,330,000 37,310,000 Total plant assets $54,405,950 During 2018, the following selected cash transactions occurred. Apr. 1 Purchased land for $2,345,200. May 1 Sold equipment that cost $639,600 when purchased on January 1, 2011. The equipment was sold for $181,220. June 1 Sold land for $1,705,600. The land cost $1,066,000. July 1 Purchased equipment for $1,172,600. Dec. 31 Retired equipment that cost $746,200 when purchased on December 31, 2008. No salvage value was received. Collapse question part (a) Journalize the transactions. Novak uses straight-line depreciation for buildings and equipment. The buildings are estimated to have a 40-year useful life and no salvage value; the equipment is estimated to have a 10-year useful life and no salvage value. Update depreciation on assets disposed of at the time of sale or retirement. (Record entries in the order displayed in the problem statement. Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.)

The owner of Horne Design Wallcoverings has hired you as a consultant to design a database management system for his chain of three stores that sell wallpaper and accessories. He would like to track sales, customers and employees. After initial meeting with him, you have developed a list of business rules and specifications to begin the design of an E-R Model. The list of business rules are:

• Customers place orders through a branch
• A customer may place many orders
• A Customer does not always have to order though the same branch all the time
• Customers may have one or more accounts; although they may also have no accounts.
• Customer may be a member or non member with Home Design Wallcoverings. As a member, the customer can get certain amount of discount.
• Accounts related information need to be recorded such as balance, last payment date, last payment amount and accounts type
• A branch may have many customers
• A branch may sell all items or may only sell certain items
• Orders are composed of one or more items
• Items may be sold by one or more branches
• An item can be composed of multiple items: for example a dining room wall covering set may consists of wallpaper and borders
• Home Design Wallcoverings employs 54 employees
• Each employee have one or more dependents
• Employees can have one or more skills

Questions / Requirement:

You are required to design a database solution for the above case study by coming out with the following parts:

1. Identify the entities and provides the possible attributes for each entity.
2. Draw Enhanced Entity Relationship Diagram using either Crow’s Foot model. Specify primary keys and cardinality in your diagram.
3. In cases where the above requirement specification is ambiguous, state clearly the assumptions which you made for justifying your modelling choices
4. Create the tables identified from the above using SQL code (only need the codes to create the tables) – it’s fine even the tables are not go through normalization.

1.The procedure used to align many sequences at the same time is called: *

• diversity sequence alignment
• multiple sequence alignment
• local alignment
• multiple statistical alignment
• substitution matrix alignment

2.The method of alignment that tries to align regions with high level matches without considering the alignment of the rest of the sequence is called: *

• global alignment
• multiple sequence alignment
• local alignment
• multiple statistical alignment
• high level matching alignment

3.The type of sequence alignments that is most suited for finding conserved patterns in DNA or protein sequences is called: *

• global alignment / multiple sequence alignment
• local multiple alignment
• local alignment / multiple polymorphism search
• multiple statistical alignment
• high level matching alignment

4. An outbreak of pneumonia has occurred. This outbreak appears to involve a family who had attended a family gathering and wedding ceremony. The samples from the patients were then tested by PCR using the primers for 16S rRNA and RT-PCR using primers for SARS and SARS-CoV-2 coronaviruses. Select statements that are TRUE pertaining to the case involving this family. The sequence of the amplified fragment from the PCR is provided here: AACACGGAGAGTTTGATCCTGGCTCAGAACTAACGCTGGCGGCGCGTCTTAAACATGCAAGTCAAGCGGAGTAGCAATACTCAGCGGCGAACGGGTGAGTAACACGTGGGTAATCTTCCTCTGAGTCTGGGATAACTTTCCGAAAGGGAAGCTAATACTGGATGGTCCCGAGAGATCACAAGATTTTTCGGGTAAAGATTTATTGCTCGGAGATGAGCCCGCGTCCGATTAGCTAGTTGGTGAGGTAAAGGCTCACCAAGGCGACGATCGGTAGCCGGCCTGAGAGGGTGTTCGGCCACAATGGAACTGAGACACGGTCC ATACTCCTACGGGAGGCAGCAGTTAAGAATCTTGCTCAATGGGGGGAACCTGAAGCAGCGACGCCGCGTGAACGATGAAGGTCTTCGGATTGTAAAGTTCAGTAAGCAGGGAAAAATAAGCAGCAATGTGATGATGGTACCTGCCTAAAGCCACCGGCTAACTACGTGCCAGCAGCCGCGGTAAAACGTATGGTGCAAGCGTTGTTCGGAATCATTGGGCGTAAAGGGTGCGTAGGCGGACATGTAAGTCAGGTGTGAAAACTGCGGGCTCAACTCGCAGCCTGCACTTGAAACTATGTGTCTGGAGTTTGGGAGAGGCAAGTGGAATTCCAGGTGTAGCGGTGAAATGCGTAGATATCTGGAGGAACACCAGTGGCGAAGGCGACTTGCTGGCCTAAAACTGACCCTGAGGCACGAAAGCGTGGGTAGTGAACGGGATTAGATACCCCGGTAATCCACGCCCTAAACGTTGTCTACCAGTTGTTGGGGGTTTTAACCCTCAGTAACGAACCTAACGGATTAAGTAGACCGCCTGGGGACTATGCTCGCAAGAGTGAAACTCAAAGGAATTGACGGGGGTCCGCACAAGCGGTGGAGCATGGTGGTTTAATTCGATGATACGCGAAAAACCTCACCTAG GCTTGACATGGAGTGGAATCATGTAGAGATACATGAGCCTTCGGGCCGCTTCACAGTTGCTGCATGGTTGTCGTCAGCTCGTGTCGTGAGATGTTGGGTTAAGTCCCGCAACGAGCGCAACCCTCACCTTATGTTGCCATCATTCAGTTGGGCACTCGTAAGGAACTGCCGGTGACAAACCGGAGGAAGGCGGGGATGACGTCAAATCCTCATGGCCTTTATGTCTAGGGCAACACACG *

• The pathogen is a type of coronavirus.
• The physician can inform the family that they are suffering from a disease called leptospirosis.
• The patients should be quarantined because they have COVID-19
• The pneumonia is due to a bacterial infection.
• The pneumonia can be treated with antibiotics.

5.Your research group has just completed the genome sequencing for a new bacterial species named V. novela. This newly sequenced genome has not yet been annotated. Your colleague has been studying the VTOX protein in E. modeli for many years and is interested in finding out whether a homolog for the VTOX protein can be found in the bacterial species V. novela. Select the options that are TRUE that can be used to provide an answer to your colleague.

• Do a blastn against the PDB database.
• Use the blastp program with the VTOX protein as the query to search the UniProt database.
• Use the VTOX protein sequence as a query for the tblastn program to search the V. novela genome as the database.
• Search the E. modeli database using tblastn and the VTOX protein as the query.
• Carry out a gene prediction for the V. novela genome and use the resulting genes as blastx queries to search a protein sequence database.