relational-database Questions
7
Solved
I have 3 MySQL tables for a membership system.
users: Minimum requirement to be a user, only related to account info (email, password, is_activated, etc)
user_profiles: Personal information provi...
Bursarial asked 27/4, 2011 at 21:20
5
Is there such a software out there? It doesn't matter if the data itself make sense. I am just worried about the fields to get populated. Basically, it will read the table definitions and generate ...
Pleurodynia asked 25/3, 2013 at 5:46
6
I have a few XML files containing data for a research project which I need to run some statistics on. The amount of data is close to 100GB.
The structure is not so complex (could be mapped to perh...
Tarazi asked 30/11, 2012 at 11:20
4
I wasn't sure quite what to call this problem but it's not exactly counting rows. Let's say we have the relation:
Competition(compId, sport, playerName, medal)
And let's say the attribute medal ...
Barbiturism asked 11/9, 2013 at 23:16
4
Computer science student trying to get my feet wet with android development. I am trying to build an app where I am pretty sure a graph database is going to be required (its an app the creates rela...
Attain asked 2/2, 2016 at 19:12
4
If a procedure fails in middle, are changes at that point from the beginning of SP rolled back implicitly or do we have to write any explicit code to make sure that SP runs in a transaction only?
Platonism asked 31/1, 2015 at 10:2
3
Solved
I have 2 tables, User and Employee. Each user is given a User_ID and that is a primary key in the User table and a foreign key in the Employee table. Can that attribute in the Employee table also b...
Refresh asked 11/2, 2012 at 22:2
3
Solved
Partial indexes only include a subset of the rows of a table.
I've been able to create partial indexes in Oracle, DB2, PostgreSQL, and SQL Server. For example, in SQL Server I can create the index...
Nurserymaid asked 20/3, 2018 at 23:44
9
Solved
I've got 3 relevant tables in my database.
CREATE TABLE dbo.Group
(
ID int NOT NULL,
Name varchar(50) NOT NULL
)
CREATE TABLE dbo.User
(
ID int NOT NULL,
Name varchar(50) NOT NULL
)
CREATE ...
Idiolect asked 21/10, 2011 at 2:51
1
Solved
I have a menu that can have multiple Sections. I have passed the menuID of a ShopMenuEntity as foreign key in ShopSectionEntity with name fk_menu_id.
Both id's have to be autoGenerated in ShopMenu ...
Premise asked 5/8, 2023 at 6:57
8
Solved
Can someone explain to me the advantages and disadvantages for a relation database such as MySQL compared to a graph database such as Neo4j?
In SQL you have multiple tables with various ids linki...
Greer asked 24/10, 2012 at 9:31
6
Solved
I have read the following:
What the difference between mysql and mysql2 gem
So far I have only used MongoDB with NodeJS and I want to be able to learn MySQL for any of my relational database needs....
Lallage asked 16/8, 2014 at 22:40
1
Solved
I need to add an empty migration to write a SQL query and manipulate the data manually.
There is no change in my schema and basically, I just need to apply this query to my existing data.
Aweinspiring asked 15/3, 2023 at 15:26
3
Solved
I want to start using table relations in a new project.
After some googling I got 2 tables set up as InnoDB:
The keys I want to link are
->users->userid (primary)
->sessions->userid (index)
The...
Buffalo asked 21/3, 2011 at 20:56
6
Solved
What are the non-trivial functional dependencies in the following table?
A B C
1 1 1
1 1 0
2 3 2
2 3 2
What the basic concept?
Gwendolyn asked 10/4, 2014 at 15:24
6
Solved
i am a student just starting out with python, and i was tasked with creating a relational database management system. I think i came pretty far, but i seem to have hit a wall. This is my code:
imp...
Teplitz asked 28/11, 2017 at 20:42
7
Solved
One of the core rules for the relational model is the required uniqueness for tuples (rows):
Every individual scalar value in the database must be logically addressable by specifying the name of...
Destinee asked 10/6, 2015 at 21:23
3
Solved
I'm not quite sure if I understand the associate method in Laravel. I understand the idea, but I can't seem to get it to work.
With this (distilled) code:
class User
{
public function customer...
Saving asked 2/10, 2014 at 12:19
2
Solved
I have a model Project and i am getting the attributes of that with the following instr
attr = getattr(project, 'id', None)
project is the instance, id is the field and None is the default retur...
Wivern asked 27/11, 2013 at 6:54
4
Solved
What I'm really looking for would be the equivalent of a lightweight database snapshot that could be further modified.
The database could be huge, but the snapshot itself should be tiny and ...
Hecht asked 11/5, 2012 at 17:4
2
Solved
Assume there is a bank, a large shop, etc, that wants the accounting to be done correctly, for both internal accounts, and keeping track of customer accounts. Rather than implementing that which sa...
Schorl asked 21/12, 2019 at 1:54
2
Solved
I have 2 tables as you will see in my PosgreSQL code below. The first table students has 2 columns, one for student_name and the other student_id which is the Primary Key.
In my second table called...
Be asked 17/2, 2015 at 9:44
6
Solved
Currently my users table has the below fields
Username
Password
Name
Surname
City
Address
Country
Region
TelNo
MobNo
Email
MembershipExpiry
NoOfMembers
DOB
Gender
Blocked
UserAttempts
BlockTime
...
Chang asked 4/7, 2011 at 22:8
3
Solved
I would like to add a prefix to all columns that result from a left join.
left_join() has the possibility to add a suffix when names are identical between the two tables being joined. But, it doe...
Batey asked 24/10, 2016 at 20:1
5
Solved
I am trying to create a table with a varchar column as foreign key but MySql gives me an error while creating the table. My query is like this:
CREATE TABLE network_classes (
id TINYINT(1) UNSIGN...
Bullet asked 22/8, 2013 at 14:23
1 Next >
© 2022 - 2024 — McMap. All rights reserved.