Discuss the main characteristics of the database approach and how it differs from traditional file systems. Create a Crow\'s Foot ERD to include the following business rules for the ProdCo company: Each sales representative writes many invoices. Each invoice is written by one sales representative. Each sales representative is assigned to one department. Each department has many sales representatives. Each customer can generate many invoices. Each invoice is generated by one customer. Explain the following terms with example. Entity integrity Referential integrity Consider the following database information and Make the necessary assumptions about the other relationships and draw an E - R diagram. Each airline has an identification number, a name and address, a contact person\'s name, and a telephone number. Each aircraft has an aircraft identification number, a capacity, and a model. Each employee has an employee identification number, a name, an address, a birth date, a gender, a position within the company, and a qualification, of money paid/received. Each route has a route identification number, an origin, a destination, a classification (domestic or international route), a distance of the route, and a price charged per passenger. e. Each airline records information about its buy/sell transactions. (For example, selling an airplane ticket is a sell transaction; paying for maintenance is a buy transaction.) Each transaction has a transaction identification number, a date, a description, and an amount. > Each employee works for exactly one airline. Airlines assign different aircraft on different routes based on the availability. Furthermore, each airline makes one or more transactions; however, each transaction is associated with exactly one airline. Convert above ER diagram into relational schema.
1) A Database is a collection of interrelated data which is stored in database server.The data will be stored in the form of tables.
There are number of characters that differ from traditional file management system.
In file system approach, each user defines and implements the needed files fora specific application to run.
For example in sales department of an enterprise, Oneuser will be maintaining the details of how many sales personnel are there in the salesdepartment and their grades, these details will be stored and maintained in a separatefile. Another user will be maintaining the salesperson salary details working in theconcern, the detailed salary report will be stored and maintained in a separate file.
3)
a) entity integrity:
Entity Integrity is the mechanism the system provides to maintain primary keys. The primary key serves as a unique identifier for rows in the table.Entity Integrity ensures two properties for primary keys:
b)Referncial integrity:
Homework Sourse
