I never made something similar . I have a system and i need to relate my data with external data(in another database).
assuming that you have the following sentence in a requirements document The system has to keep track of the names of publishers, their
Imagine an e-commerce website where users can create their own stores. I\'m designing internal messaging system for such website, and I\'m currently hesitant as to how to implement it database-wise.
I have this first query. SELECT item.id, item.name, item.description, item.tnURL, item.spec_id, item.item_type, item.sub_category
FYI: I explicitly mean SQL Server 2000-8 and C#. So DBMSs with enum support like MySql is not the subject of my question.
I have a set of objects which can be members of one or more of a low number of sets (think objects which can sit in several positions inside a tree). Since these assignments need to be queried often a
I\'m designing a program along with its database from scratch. Wha开发者_StackOverflowt would be the best database design for the following scenario (SQL 2008 R2, C#):
I\'m a student learning SQL and PHP, I have been set a task to create a student feedback form using PHP and mySQLi, and im really stuck at getting my head around how to design the database for the pro
Database relationship cycles smell like bad database design. Below is a situation in which I think it can not be prevented:
When I design a data model in Visual Studio, I can only add/remove/rename entity attributes. Is it possible to rearrange the fi开发者_C百科elds already present (considering model-first process, meanin