Entity Model Help
I have the following model in my database, but I'm a bit confused on what I should do.
If I have the Seat table how it is, it will end up creating so many rows, A - 1, A - 2 etc
How can I have this data split so it doesn't do this? I wanted the seatRow and seatNumber separate so I can easily match the values around the program.
Thanks
In the given scenario I don't see the problem with having a large number of rows in the seat table. Which is what I believe you are alluding to.
Lets say you have a venue that has 1000 seats over 100 rows.
- If you split the tables you have 1 table with 100 records and 1 table with 1000 records.
- If you leave them together you have 1 table with 1000 records.
If you followed all normalisation rules you would only end up merging the two tables back together. The design looks fine for what it is. Placing the SeatRow and Number together would have no bigger or smaller impact on the number of rows. It's a smart idea to leave them split. Microsoft SQL Server would have no problem with this architecture and indexing it for performance. For Access and other file based databases I'm not familiar with the indexing policies so I can't comment.
- Extracting valid timestamps in SQL
- MySQL union - alias not visible
- SQL count occurrences based on values in other columns
- Find values that are 6 characters long in a string, pipe delimited
- How to write this SQL query to find each account balance?
- SQL Query to get latest price
- Join newest price from price-table for all products
- Order By In a SQL Table Valued Function
- Return columns with a single value
- Missing FROM-clause entry for a table
- Convert JSON to table when all JSON field keys are unknown/arbitrary/random
- select multiple cells inner join one table
- Split a string with no delimiters into columns
- SQL query to get the employee who has not been appraised
- TOAD for Oracle, variables for schema/ table names
- TSQL Pseudo Random text generator
- Get user last purchase date from specific product in WooCommerce
- Recursive CTE in Postgresql
- Add missing dates in a table
- ORACLE APEX ADMIN LOGIN ISSUE
- Cast value to type (TEXT) using string representation of type ("TEXT")
- Get records that have total count of over X amount
- Excluding records between dates AND with an associating value
- Turn cell values into columns in MySQL
- SQLdevelopersfruit puzzle
- SSIS Error: External Column for Source out of sync with Data Source columns; How do I remove External Columns?
- Fetch last row for each month, or previous month if not found
- Convert table with columns as path (bread crumbs / levels) to hierarchy (tree) representation
- How to create table like another table with additional columns in MYSQL
- Connecting to Microsoft SQL server using Python