Category: Databases

A balanced tree is one of the data access techniques in a database. How does it work? How
data can be inserted in. How data can be deleted from it; how data can be updated? And
how data can be reviewed? By giving an example explain all of them. Your report must
be prepared as seen in the following template.
Here is the template of the report:
Steps Actions
1 Name of the report and date
2 Author of the report
3. Literature review
4. Your contribution
5 Explanation of each process as detail as much on figures.
6 Summary
7. Future advice
8. References

Consider the following database
Room (room_no,room_name,room_type,charges)
Guest(Guest_code, Gname,city)
The relationship is as follows: Room-Guest: one-to-one. room_type can have values as either AC or
NonAC.
Q 2) A Create the above database in PostGreSQL and insert sufficient records.

Hey , I am a begginer in vb.net and I want to retrieve my data from access database as well as manipulate indivial record according to my choice..Can you help me with this
Thanks & Regards

Database of clothing shop

I am starting an online business with an American lady. I don't know anything other than her phone number. So want to verify her records.

<?php
$pdo = new PDO('mysql:host=localhost;port=3306;dbname=crud', 'root', '');
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$title = $_POST=['title'];
$description = $_POST = ['description'];
$price = $_POST = ['price'];
$date = date('Y-m-d H:i:s');
$products = $statement = $pdo->prepare("INSERT  INTO products (title, image, description, price, Create_date)
VALUES (:title, :image, :description, :price, :date)");
$statement->bindValue(':title', $title);
$statement->bindValue(':image', '');
$statement->bindValue(':description', $description);
$statement->bindValue(':price', $price);
$statement->bindValue(':date', $date);
$statement->execute();

?>

Getting started with PromQL can be challenging when you first arrive in the fascinating world of Prometheus; here’s a PromQL cheatsheet with interesting tips. Since Prometheus stores data in a time-series data model, queries in a Prometheus server are radically different from good old SQL.

Understanding how data is managed in Prometheus is key to learning how to write good, performant PromQL queries.

Hi

Please help I'm getting this error on a perl script

DBI->connect using 'old-style' syntax is deprecated and will be an error in future versions at /home/dbadmin/perl/adm_audit_mhs line 43

$dbh = DBI->connect('xe', 'ops$dbadmin', 'm00nwalk', 'Oracle') or die $DBI::errstr; (this is line 43)

Thank you in advance

I have a snippet that inserts data in a row in a MySql database. If that data already exists the existing row should be updated. In my case, I continue to get insert only. What is wrong with this snippet?

Hello all I am having problem with functions. Always getting Error(7,11): PLS-00323: subprogram or cursor 'EMPLOYEE_EMAIL' is declared in a package specification and must be defined in the package body. My package body.

Hi. I'm trying to set up an AMP system on my machine. It's called UwAmp. Anybody there to tell me how to setup the MySQL in this thing? Thank you

Good day, I am actually a young programmer, who wants to develop a webpage that enables someone to take a practice test. It was given to me as an assignment that determines if I will remain a programmer. I know little about PHP codes but none in Mysql. I came to the website and noticed a discussion from @broj1 with another programmer. I don't have a code in mind yet or how I should start about it but I would a really appreciate a little help. All I have been able to do is a direct html quiz and the assignment is to be submitted on Friday. I really need help. Thanks

Hi everyone I am wondering if someone can help me understand why the Sub-Query's SELECT statement ended up producing the column name 'Code' vs. the initial SELECT statment call 'local_name' in the below screenshot Thanks in advance!

I have a database where there is an table wm for water meters :

    +------+---------------+
    | Code |     name      |
    +------+---------------+
    | wm1  | water meter 1 |
    | wm2  | water meter 2 |
    | wm3  | water meter 3 |
    +------+---------------+

and another table counters where there are counters value :

    +------+---------+-------+------------+
    | Code | Code_wm | value | created_at |
    +------+---------+-------+------------+
    |    1 | wm1     |   100 | 2020-10-18 |
    |    2 | wm1     |   0   | 2020-10-19 |
    |    3 | wm2     |   0   | 2020-10-18 |
    |    4 | wm2     |   100 | 2020-10-19 |
    |    5 | wm3     |   0   | 2020-10-18 |
    |    6 | wm3     |   100 | 2020-10-19 |
    +------+---------+-------+------------+

i want get this result :

    | code_wm | result |   Date     |
    +---------+--------+------------+
    | wm1     | 0-100  | 2020-10-19 |
    | wm2     | 100-0  | 2020-10-19 |
    | wm3     | 100-0  | 2020-10-19 |
    +---------+--------+------------+

but when i try :

SELECT code_wm , LAG(value,1,0) OVER ( ORDER BY code_wm) as result
FROM counters 

i don't get the correct result : https://www.db-fiddle.com/f/7TuSTaukG336tqnTNDg4em/0

Hello
Could I please ask for assistance? I need a file that I am able to download that holds all the streets and postal codes of the Ireland.