Create a database in MS Access to assist a fictitious company on preparing its sustainability report. You need to make up all the data that is need to create the database. The company may be able to be an apparel company like aidas [login to view URL]
For the database, the requirement is following:
The database must include at least 15 tables and 15 queries. Populate the database with fake data. You decide on the number of records, but include enough records to test the queries.
・The database should include tables to disclose at least greenhouse gas emissions and water use. Other topics (waste generation, electricity use, ...) may be included.
・Queries must include retrieving fields from one or more tables, conditions on one or more fields, outer joins, and queries including group by, is null, and having
・The database should include all types of relationships.
・The database must include referential integrity and at least three field controls and one table control.
・Relationships with a minimum cardinality of one must be enforced.
7 freelance font une offre moyenne de $18/heure pour ce travail
I'm a BSc degree holder in computer science. I have worked on more than 1000 papers in report writing, research.I have read and understood your requirement and I know you will never regret, thank you.