Deadline is less than 1 day - I have to create tables and quires and relationships for an assignment using access. I have tried but i am a bit stuck and need some help. I also would like the explanation behind the solution so i can learn from it as well. This is what i have to do: 1: Convert a entity-relationship model provided into a relational database design. I have done this but need advice if done correctly. 2:Create the tables (6) in a database according to your relations from the previous step. I have done this but not sure that i have "Pay careful attention to physical design requirements, including data types and sizes, integrity constraints, indexes, etc; your choices should be aimed at ensuring data integrity. or paying attention to referential integrity and cascade options." 3:Formulate SQL quires. I have attempted most of them and research on the net but having trouble with a few of them. This inclueds: *"DateDiff" * I think a "sum" but with date specific crieteria. *write two separate queries and use a UNION to show both results sets in the output, not showing duplicate rows. 4: Need to create a form based on the tables. I have done this but would like someone to check it and give advice. It is not too hard, but i do need help cause i study distance education it makes it harder as i have no international with others. If you can help by writing a brief description or reason for each question that would help me. I can email you the database if yo are interested.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):
a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Microsoft Access 2003 or 2007