New answers tagged


Short answer: Client-server. You have a client, you have a server, you have a school project, so there we go. Longer answer: "I'm using dimensional lumber and wood-screws to build my house. What architecture am I using?"


You can use same name to parameter as attribute of a table,but it is not a good way. It might be ambiguous enough in some procedures/functions that they’re problematic too. you can use following way: Simplest way to distinguished between your parameter and column (if both name is same) is to add table name in your column name. select count(orderNumber) ...


1 course has many rooms 1 room has many courses 1 course has many sections 1 section has 1 course (? Or can the same section appear in multiple courses?) If a section always occurs in a particular room for a particular course, then it depends on the course-room entity that decomposes the many:many relationship between courses and rooms. This thus ...


Foreign key mapping is a proven technique for implementing a one-to-many relationship (not mandatory, i.e. 1 - 0..*). So having a foreign key in shipment_data that refers to shipment's primary key would allow no, one, or many shipment_data for a specific shipment. Using the foreign key as a primary key is possible. It requires you to first ...

Top 50 recent answers are included