The course is defined as a section. For instance, a course NUR567, can have multiple sections, and each section can have many students, but a student can be enrolled in one only one section. A section is identified by courseid, sectioned, semester, year, and begin and end dates. Assume that students are defined by student ID. student name, major, and status.   In an ER diagram, draw this relationship between section and students Write the four statements and decide on the number of tables. Include SQL statements.

Example of formatting below.

 

A music album has a lead artist. A lead artist can have multiple albums. An album must have a lead artist, but a lead artist can exist (as in preproduction) without any albums. The attributes of a lead artist are name, address, city, and agent telephone. An album has a product code, production date, and price. One Liner: A lead artist has albums ER Diagram: LeadArtist artistID (PK) name address city agentTelephone Four Statements: (1.1) has Album albumID (PK) product Code production Date (0,*) price artistID (FK) Maximum Cardinality: One lead artist can have multiple albums. One album can have only one lead artist. Minimum Cardinality (Participation):