The main problem is that it's a loosely structured, report focused database. The OP is experiencing the headache of maintaining this visual first design. We are now 145 posts into "Clear out data"
I disagree. AI won't hurt seasoned developers any more than MZ-Tools or similar utilities. You still need to understand the basics.
It's like putting two drivers in race cars, one a professional and the other a novice. The outcome will be vastly different.
I took the liberty to ask ChatGPT to look at the following picture and redesign the schema to N3 with joins.
The redesigned database as follows
🔶 MAIN TABLES (Entities)
1. FamilyMember
FieldTypeNotes
MemberIDAutoNumberPrimary Key
FirstNameShort Text
LastNameShort Text...
I'm sure this has been mentioned.
Each family member has a unique login that prevents them from seeing other sensitive records, no need to delete any records because they can only access their own personal account.
I see the economy as doing okay because I check the S&P 500 every morning. What I see is one crash followed by a lot of new highs. The tariff issue seems to be giving way to solid trade deals with our partners. I’ve also noticed that no matter how high the stock market climbs, it barely gets...
It's the same argument used against tariffs, if you dare impose them, prices will skyrocket. If undocumented workers are removed from construction sites and other industries, prices will rise. But maybe prices are artificially low because we choose to ignore reality. Maybe we need those...
This is a fascinating read. It reminds me of the mistakes I made early on with my first databases. Those were frustrating times, trying to apply best practices to unorthodox designs. Man, that was tough.
@Thales750 My question was about the health of the economy currently. Typically, when the economy is strong, the previous administration tries to take credit. But if it’s struggling, the current administration gets the blame. Your stance seems to be that none of that matters Trump’s an idiot...