What are three main steps associated with building erd

Assignment Help Computer Engineering

Reference no: EM132116022

Q1: Suppose that your uncle is a real estate agent and he decided to have a web-site to list his available real estate properties. And use a laptop computer to show clients these properties. What hardware is needed to have a web-site and client to browse the properties on that web-site? How many (n-tired) computers are needed for this system? List at least one advantage for this new system?

Q2: What are three main steps associated with building the (ERD), list these three steps?

Explain how do you represent, 1-to-1 (1:1), and 1-to-many relationship (1:N) and many-to-many relationship (M:N) ?

Q3: Case Study: describe using ERD diagram how the university can manage Building, Classroom, Course, students, and Instructors, each of which is a table that is drawn indicating Primary Key, and Foreign key. Then explains how the university can add a new course without conflicting with others courses' time and classroom.

Notice: the relation between Course and Student is m-to-m because a Student may have more than one Course has more than one student.

Draw the ED-D using crows-feet notation. Show the entities and relationships between entities (Building, Classroom, Course, student, Instructor). Indicate the PK primary key, and FK foreign key in each table)

Reference no: EM132116022

Questions Cloud

What is the lower limit of the confidence interval : What is the lower limit of the confidence interval? What is the upper limit of the confidence interval?

Student with the score : What proportion of students had a higher score than the student with the score than the student with the score of 940?

Distributed denial-of-service attack : What are the recommended criteria by security experts of choosing passwords for your accounts (only four)? And why we should apply such criteria?

Describes which of the following market myths : Private markets are perfectly efficient only if there are no public goods, externalities or taxes describes which of the following Market Myths

What are three main steps associated with building erd : Suppose that your uncle is a real estate agent and he decided to have a web-site to list his available real estate properties.

How is that same actor represented in the dfd diagram : Consider a system for buying a new car. The customer should inspect the vehicle and chose the type, the color and the desired characteristic.

Draw a use case diagram for the system within the project : COIT11226 — Systems Analysis - Draw a use case diagram for the system within the project - Explain the advantages and disadvantages of each of the two methods

Describe the k-means algorithm : Explain the reason behind describing artificial neural networks (ANN) as "black box". Then propose one technique to overcome this criticism.

Design a logic circuit to control the lights : A long hallway has 3 switches, which control the light. It has to be possible to turn the light on or off by changing the state of any one of the switches.

User Account

All Pages