Case Description our Company called Bella Vita provides architectural design. The Manager decided to store and maintains his business data using Microsoft Access database. And you will help him to do so … Here below you will find the data requirement for Individual database submission:
The company contains departments each department has unique name, a unique number, and a unique person who will manage this department. each department has one location/address .
Each department controls a number of projects, each project has a unique name, a unique number, and a single location.
This company has many employees we need to store information such as , employee ID, full name, date of birth, address, salary and sex. each employee should be assigned to one department and can be assigned to many projects …. Now you have this info. Try to work on them and build the ER diagram, schema, and database access. After that try to fill the tables with data then submit the work.
Guidelines and Mark Distribution Read the following description about database scenario then do the following:
1. Prepare an ER diagram showing entities, attributes, relationships (with cardinality)
2. Draw the database schema
3. Build the database on access according the design, create tables, create relationships enforcing referential integrity (cascade update and cascade delete)
4. Make 5 different Queries of useful report to be used by the managers