25 Answered Questions for the topic Database

03/17/21

SQL QUESTION W3schools
This is the database that i want to use, https://www.w3schools.com/sql/trysql.asp?filename=trysql_op_inFind the average price for all the products from the USA supplier.
Follows • 1
Expert Answers •1
Database Sql W3schools.com

03/17/21

Database SQL Question
using https://www.w3schools.com/sql/trysql.asp?filename=trysql_op_in, we want to find the number of products in the table Products (the table has 77 rows) that was sold to the USA customers. No... more
Follows • 1
Expert Answers •1

12/21/20

Database Questions

1.     Discuss some applications of active databases.2.     Discuss how time is represented in temporal databases and compare the different time dimensions. 3.     What are the differences between... more
Follows • 1
Expert Answers •1

12/08/20

Please answer the short prompt regarding database storage solutions and structure. Which data storage solution is best?
Situation:You've just been brought into a company that's looking at how decisions are ultimately made by a Hollywood studio regarding casting. You have been asked to collect and store a wide... more
Follows • 1
Expert Answers •1

04/09/20

ER Diagrams - relations
The SingLanka Record Bar has decided to store information about musicians who perform on its albums in a database. Consider the following requirements to design a database for the company... more
Follows • 1
Expert Answers •1

04/07/20

Realtional Database vs File Based System
Explain the advantages of RELATIONAL DATABASE MODEL over file based system
Follows • 1
Expert Answers •2

12/18/19

Explicitly create Class for joining table or not for Java JPA many-to-many relationships
Hi,For those who have used Java JPA (Hibernate or EclipseLink) I wanted to ask your opinion on the best way to represent m2m relationships in the Entity classes. The choice as I see it is to... more
Follows • 1
Expert Answers •1

09/23/19

Give an example of a many-to-many relationship and explain its unsuitability for a relational database.
Designing a database requires both a logical design and a physical design. The logical design models the database from a business perspective. The organization's data model should reflect its key... more
Follows • 1
Expert Answers •1

07/30/19

Database Internals - Where to Begin?
So lets say that you want to learn some stuff about database internals. What's the best source code to look at? the best books to buy?I was talking about this with a buddy the other day and he... more
Follows • 1
Expert Answers •1

07/20/19

Storing Images in DB - Yea or Nay?
So I'm using an app that stores images heavily in the DB. What's your outlook on this? I'm more of a type to store the location in the filesystem, than store it directly in the DB.What do you think... more
Follows • 1
Expert Answers •1
Database Web Design Mysql

07/02/19

Godaddy's database is full and need to upgrade
What would be the best way to update database storage. whats the best solution to upgrade database storage?I can not install WordPress due to storage limitation.
Follows • 2
Expert Answers •1

06/30/19

Structured data
Hi i am doing research about Structured data and I am not able to find significant information about Structured data.What are the different types of Structured data?What are the advantages and... more
Follows • 1
Expert Answers •1

06/28/19

Is there a database of cell images?
We're working on an algorithm for processing images of cells, similar to but much more basic than [Cell Profiler](http://www.cellprofiler.org/), and we are looking for a large database of cell... more
Follows • 1
Expert Answers •1

06/26/19

Database of Multicellular and Unicellular organisms?
I'm trying to annotate a list of organisms taken from NCBI for cellularity (unicellular or multicellular). Does any of you ever found a database with association between an organisms' name or taxa... more
Follows • 1
Expert Answers •1

06/25/19

Oracle DB: delete all the contents?
I have oracle DB it is for testing purpose, I have not added any tables. I just want clear all the files like control, redo, archive, date. Ultimately I want fresh db. I know it can done by delete... more
Follows • 1
Expert Answers •1
Database Genetics Homework

06/20/19

Where should I start looking for an online gene library?
Is there an online library that includes all known genes in stored in their nucleotide form of all living organisms? I'm presuming that such a database doesn't exist. So to kick of my search, how... more
Follows • 1
Expert Answers •1

06/08/19

What is a database transaction?
Can someone provide a straightforward explanation of a transaction as applied to computing?
Follows • 1
Expert Answers •1

05/24/19

How to write a simple database engine?
I am interested in learning how a database engine works (i.e. the internals of it). I know most of the basic data structures taught in CS (trees, hash tables, lists, etc.) as well as a pretty good... more
Follows • 1
Expert Answers •1

04/23/19

Why does "Conversion from string "ID" to type integer is not valid" show on my program?
I'm trying to display my database on textboxes, with the help of the combobox for the ID. However, whenever I run my program, the error **"Conversion from string "ID" to type integer is not... more
Follows • 1
Expert Answers •1

04/14/18

i need help with PL/SQL (Oracle)
Write a complete PL/SQL program that enables a user to interact with a database of your choice (for example you may choose employee database, or student, or a library database, … etc). The database... more
Follows • 1
Expert Answers •1

04/02/18

Data Warehouses
Write a query that retrieves finance amounts from "FactFinance" in the "AdventureWorksDW2016CTP3" database and returns those amounts, organized by month, and showing a 3-month rolling average.
Follows • 1
Expert Answers •1
Database

03/05/18

Emma frequently updates a spreadsheet on her computer. How can she ensure that she doesn’t lose her data?
i dont know the answer to this question and need help
Follows • 2
Expert Answers •1
Database Java Programming

05/21/15

java swing connected to database
Create a Java Program which can do the following:1. A list of items that shows any inforamtion such as about various cars, foods etc. 2. When you click any item, the description of that item and... more
Follows • 2
Expert Answers •1
Database Html Dreamweaver Php

01/02/15

eCommerce with Dreamweaver, Please help
I have a question , Currently i Have a store Locally. However i want to put them online and sell through my website. I created a site with Dreamweaver. Basically i dont want to write code for each... more
Follows • 4
Expert Answers •3

10/22/13

Under what circumstances would you use a sequential file over a database?
Under what circumstances would you use a sequential file over a database? Describe these circumstances. When would a database be more beneficial than a sequential file? Is it possible for the two... more
Follows • 3
Expert Answers •4

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.