Question

PLEASE HELP, WILL GIVE THUMBS UP ON ALL MY ACCOUNTS, PLEASE FOLLOW CAREFULLY

This practice will aid you in creating an ERD diagram. Explaining the entities the relationships and all the cardinalities that your business holds. Write up a database application to solve a business problem. This is to describe the nature of the problem or a solution to the problem. You are able to use any business as your written ERD diagram ie:  a Lifetime Fitness gym, any college school, a pet store, a car distribution center,  a super market.   

Ex: Super market: you can write about ENTITITES + relationships include Vendor to Distribution center to etc.

Include five to seven entities as well as the relations of it : one to one, one to many, many to many

(DBMS) Type up TWO to FOUR pages proposal (in any Word document) that includes all below

1 the intended problem for application to address.

2) displays/list the involved attributes and asw well with the entities along with the types of data

3) display the business rules, cardinalities/relations that are involved with the entit. constraint, attributes if there are any. If there's null fields explain why

4) include the descriptions of the ERD diagrams  P/F (primary and foreign) keys, as well as the   constraints and the relationships

5) and lastly outline your applications functionality. Ex: what can the users do with this application, what the application serves . Explain.

Proposal should have between 5 and 7 entities, and include the (multiple) relations (One to one, one to many, many to many etc )

Answer 1

Consider the School Database with the following Entities

1.Student

2. Class

3.Teacher

4. Guardian

5.Fee Details

Relationships:

1.Each Class has many Students(one- many)

2.Each Student has one Guardian(one-one)

3. One teacher can teach in several classes and in one class several teachers can teach different subjects(many-Many)

4.One Student can be taught by many teachers and one teacher can teach many students(Many-Many)

5.Each student pays the fee every month (one -many)

Below is the ERD Diagram with underlined attributes as primary keys, outlined attributes as foreign keys

DateofBirth Class TeacherlD Name Class TeacherlD Section Standard FeeDue Studentl StudentiD Class has Student pays RoomNo Fee Details has has FeePaid Teaches GuardianName TeacherID Teacher Guardian DateOfBirth StudentiD Subject EmaillD Name Relationship Phone Phone Number