1-Explain relational schema. Also explain how it is different and similar to a relational diagram, and entity...
Question:
1-Explain relational schema. Also explain how it is different and similar to a relational diagram, and entity relationship diagram (ERD). In essence, you are to define, explain, and show how they are similar or different. It should also include the sequence of how the diagrams are used in the database design and development process. Make sure to include pics, diagrams, or examples to
provide a mental picture for the reader.
2. Make a relational schema of the four entities. Make sure to include all the necessary information for each relation.
3. Make an ERD in Visio of the four entities.
4. Use SQL Server or SQLite to implement the ERD. Add one row of data. Make sure to display the data in each table.
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George