Page 1 of 1
Q1. DESIGN Phase: [1.21181 1. Design the Entities/Relations and their meaningful Attributes. 2. Employ Relationships bet
Posted: Fri May 20, 2022 3:30 pm
by answerhappygod
- Q1 Design Phase 1 21181 1 Design The Entities Relations And Their Meaningful Attributes 2 Employ Relationships Bet 1 (41.14 KiB) Viewed 40 times
Q1. DESIGN Phase: [1.21181 1. Design the Entities/Relations and their meaningful Attributes. 2. Employ Relationships between the Entities. 3. Draw the ER Diagram for your database. 4. Use the mapping technique to map ER to Relational database Schema. Q2. IMPLEMENTATION Phase: (2.21181 Develop your Database and tables in SQL Server Management Studio. Your database must have queries that represent: 1. Insert command, you need to insert at least 7 data Record into database tables. 2. At least 5 Select statements to validate data model, the SQL command must include queries for 2 or more tables, 3. At least one update. 4. At least one delete option. 5. At least one Alter Q3. Applying Constraint: [1.2||21 12.2121 1. Create a suitable Primary key for each relation. 2. Create a suitable name for attributes. 3. Your database must be in 3NF. Best of Luck