Question : To start, I have no technical experience. I own a home services business and I want a mySQL […]
Category: Database Design
Decomposition In Boyce-Codd Normal Form may lose relations?
Question : Let be the following Realtion R={UtilisateurID, Nom, Prenom, AdresseEmail, Login, Passwd, ServeurMail} with the functional dependencies: F = […]
Need a better approach in how to design this relation
Question : I have a table fluxo, and fluxo have many fluxo_acao, but a entry in fluxo_acao can have three […]
database design for storing individual users’ items
Question : I am trying to make an application which users can have their own account For the account, I […]
Datatype for a Persisted Computed Column? Should I Convert/Cast When Creating It?
Question : What is the Datatype for a Persisted Computed Column? (a) Does SQL Server automatically infer it? (b) Also […]
Duplicate column or foreign key lookup?
Question : I have a base user profile table that stores data for users. Each user is able to upload […]
Are there any advantages to having SQL hosting separate from a website? Hosting my own servers or paying for a service? [closed]
Question : Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the […]
How many databases does a sybase instance have?
Question : I’m a newbie to sybase and could not find the clear answers on Sybase tutorials/docs How many databases […]
Oracle Creating ER Diagrams and Data Dictionaries
Question : I am new to Oracle Databases and would like to develop a data dictionary and ER Diagrams for […]
Database design: Combining good schema design with good user experience
Question : Context I am designing a table schema for a solution that will track “punishments” issued by multiple clients. […]