I have the following database relationship and query for PostgreSQL below: create table gender( gender_id int primary key, gender char(10)) create table student( student_id int primary key, first_name char(50) not null, last_name char(50) not null, gender_id int not null, constraint…
I am currently writing a pet project for an online store in React. I'm using a db.json file, which stores all the data I need (store products, categories, etc.) I ran into a problem when I need to query the…
I am allowing user to upload an avatar (profile image) in their profile. While uploading avatar is entirely optional, if user does not have avatar, a default image will be used. However, checking whether a user has an avatar uploaded…
I have the following movie database relationship diagram and used the queries below to create the tables and its keys as shown below: The following are the codes that I used to create these 4 tables and inserted the data:…
I am attempting to create database in postgres docker container using createdb command. It creates database, but I also get an error message: psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory and I am…
I am designing a DB schema for a meal planning application. Each meal plan consists of blocks (2 months of diet, 2 months of bulking), each block of meals for the day, each meal of the day of foods. I…
create table phone_log(phone_number CHAR(20) NOT NULL, area_code CHAR(10)); INSERT INTO phone_log(phone_number) VALUES ('310-430-9201'); INSERT INTO phone_log(phone_number) VALUES ('917-829-2876'); INSERT INTO phone_log(phone_number) VALUES ('424-917-1055') How do I insert the area code of each phone number using the SUBSTRING FUNCTION for each…
I have read this AWS blog post: https://aws.amazon.com/blogs/database/part-2-scaling-dynamodb-how-partitions-hot-keys-and-split-for-heat-impact-performance/ I am trying to reproduce the DynamoDB partition split. My setup is the following: 1 DynamoDB table on-demand containing big items with the same partition key for all I am running this…
I created an online store website on React. Now, the data is loaded from a local .json file. I also need to create an admin panel so that the site administrator can add/change/delete cards and data himself. How can this…
When I am executing other funcitons like find, add in database then they are running perfectly fine , but when I am updating the database entry then I am getting this error , I am using mongodb atlas, can someone…