create a database must be meanungful with at least 5 tables each table have at least 5 fields and at least 12 tuples .print out the creation process (data definition) and the initial database.
option for the project( auto sales , or auto rentals or retail store if you using retail sore let me know what kind of buisiness.
make up queries(must be meaningful) which contain the specified words or functions described below, and execute them(get the answers)also explain the query in words.
please use **SQL in access view** where you need to create your own query using the plank page in access.
(A) single table query
[login to view URL] compound condition( AND/OR)
[login to view URL] [login to view URL] LIKE
[login to view URL] ORDER BY
5. COUNT
[login to view URL]
[login to view URL] BY
[login to view URL]
(B) MULTIBLE TABLE QUERY
[login to view URL] tables
2. join a table to it self(ALIAS)
[login to view URL] IN (with subquery)
[login to view URL] NOT IN
[login to view URL] UNION
[login to view URL] ANY ( or SOME)
(C) Updates
[login to view URL] UPDATE
[login to view URL] INSERT
[login to view URL] DELETE
[login to view URL] NULL
provide proper documentation
software and hardware specification
intro about the database.
screen shot for every thing was done.
## 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
melinium ,xp access 2000