To continue the discussion, my final CIS course at college is based around the two classes constructing a fully operational IS system for a local camp. The two classes are split into four groups. My team is the database group. Right now we're talking very specifically about relational and flatfile databases. Ours is definitely gonna be relational. Our group has developed level 1 and level 2 entity relationship diagrams. This week we're actually taking the level 2 ERDs and transforming them into Access tables using SQL.
Anyone have tips on doing this? We have to make approximately 50 tables in this database, all with at least 4 attributes. Is there an easier way to do this other than going into Access and manually creating 50 fucking tables? I have 3 days to get these done.
All tables must be related to each other with three levels of normalization. Thanks for any comments or suggestions.
-Lasereth