Search results

I have been normalizing tables, because of my problem trying to relate the tables by menu cycle, by day, and by diet. In the process I ended up created a menu subsystem. These were the related tables I restructured: MenuByCycle MenuByCycle (PK) Year CycleID...

Right now I am focusing on the Menu system, then the Order system, so I made reconfigured the following tables: “MenuByCycle” Table MenuByCycleID (PK) Year Cycle Day Date “MenuByCycleDetail” (Junction Table)...

My main worry at the moment is trying to create the tables and the relations for the ordering system since I see it as having two parts: 1. The Menu which includes multiple lines per type of diet for each day in each cycle of a year. The Menu is created by the Central Kitchen. 2. Then...

I just have a hard time trying to visualize how am I going to add multiple requests per type of diet and menu day in a table. There are a lot of selections of food per day, some are default meaning that are prepaired everyday, like eggs, cofee, milk, and a substitute.

I noticed that what I had just wasn’t working so I basically restructured a bit and started creating the following tables Menu tables: “MenuByCycle” Table MenuByCycleID Year Cycle Day Date “MenuByCycleDetail”...

I am having a hard time trying to create tables for a database I am trying to create. I am starting in Access but eventually it will be ported to SQL, but the forms will be made in Access. I work for a health care organization and I have been given the task to create a database for the Central...